Welcome Guest
Log In | Register )
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
PrintE-mailLink
Avatar
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.

    sfilippo's avatar - skull
    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?

    Smiley Steve

      SirMetro's avatar - center
      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

      One system I used for followers was this
        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.

        lottaloot's avatar - AvatarZ56
        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.

        Did the above ideas help you in any way?

        L ttaL   T

          Avatar
          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.