Welcome Guest
You last visited December 6, 2016, 4:15 am
All times shown are
Eastern Time (GMT-5:00)

# Help: Software or Macro

Topic closed. 4 replies. Last post 11 years ago by Andy10475.

 Page 1 of 1
Bronx, NY
United States
Member #34119
February 28, 2006
218 Posts
Offline
 Posted: April 7, 2006, 3:46 pm - IP Logged

I need software or an Excel Macro to autalculate combinations. IOW if I type in 256 I can just use the2 by  Macro or softw to quickly display dredsthe 6 unique combinations. Thanks.

Success defined: If you aim for nothing you will achieve it!
My GOAL: At least 3 straight hits per week.

Oklahoma
United States
Member #33770
February 24, 2006
3146 Posts
Offline
 Posted: April 9, 2006, 6:39 pm - IP Logged

It sounds like you want a program that does the permutations of a unique 3 digit number, correct?

If you typed in 123 it would show you...

123 132 213 231 312 321

Is that what you want?

Steve

East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
 Posted: April 19, 2006, 1:11 pm - IP Logged

The following formula will give you the lowest common number
Example 312 would be shown as 123
In this fashion, you don't need to care what the other combinations are because now you can do a sort on the lowest common number

=CONCATENATE((MIN(--MID(C2,{1,2,3},1))),(MEDIAN(--MID(C2,{1,2,3},1))),(MAX(--MID(C2,{1,2,3},1))))

986
07/31/05 - 986 - Evening - 689 - 986

Date  - ABC -  Draw  - ABC - Match Y/N ?
07/31/05 - 986 - Evening - 689 - 986

Obviously the date, ABC and draw is self-explanatory.
I then reduce the number to it's lowest box form with this formula
=CONCATENATE((MIN(--MID(C2,{1,2,3},1))),(MEDIAN(--MID(C2,{1,2,3},1))),(MAX(--MID(C2,{1,2,3},1))))

Then, I run a check to see if the next number that follows is the same as the current draw with this formula.
=IF(OR(D3=\$D\$3,D4=\$D\$3),\$B\$2,"")

If it is, I display the number that fell for the current game, if not, I leave it blank.
Keep in mind, I want the number that fell after this same number.

Next, I copy these columns to a clean sheet, using cut & Paste Special and only paste in the VALUES
You do NOT want to paste any of the formulas.

Next, simply do a quick sort on the column that does the testing.
All the blank cells will end up at the bottom with the full cells at the top.
This will be a clean sheet showing what followed.

Good Luck to all.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: May 11, 2006, 12:31 pm - IP Logged

I need software or an Excel Macro to autalculate combinations. IOW if I type in 256 I can just use the2 by  Macro or softw to quickly display dredsthe 6 unique combinations. Thanks.

L ttaL   T

Bronx, NY
United States
Member #34119
February 28, 2006
218 Posts
Offline
 Posted: May 11, 2006, 12:36 pm - IP Logged

Sorry I must have missed the responses.

Sfillipo that's what i wanted. SirMetro thanks for that formula. I have been doing it by hand, then cutyting and pasting and sorting. Great help guys. That wills ave me much time. Of course I had to change the cell refs in case --anyone else wants to use the formula. You're the Excel king SM. Thanks. It works

Success defined: If you aim for nothing you will achieve it!
My GOAL: At least 3 straight hits per week.

 Page 1 of 1