Is it Possible for Excel to Do something like ths?Prev TopicNext Topic

• Rakster

  

  Saskatchewan
  Canada
  Member #19,991
  August 9, 2005
  2,960 Posts
  Offline
  Jul 17, 2007, 10:13 am

  ▲▼

  I want to break down a number in pick 3 to every possible combination...

  Example 026

  I want to break this number into forming 026, 062, 260, 206, 620, and 602

  And if thats not enough I would like to know how I could transfer these numbers to a chart once a number is hit.

  Say 026 was called and I want to chart all box hits, is there a way to first create all 6 box plays and have them go to their coresponding spot on the chart by just typing in the 026 in an area?

  We are all Lucky... just some of us don't realize it!
  
  
• DrDan

  

  Trenton, Missouri
  United States
  Member #48,844
  January 11, 2007
  2 Posts
  Offline
  Jul 19, 2007, 6:07 am

  ▲▼

  Rakster,
     Not sure what you're asking for concerning the Charts but this is what I did.

  Column A   026

  Column B   =(CONCATENATE(LEFT(A1,1),MID(A1,2,1),RIGHT(A1,1)))*1
  Column C   =(CONCATENATE(LEFT(A1,1),RIGHT(A1,1),MID(A1,2,1)))*1
  Column D   =(CONCATENATE(MID(A1,2,1),LEFT(A1,1),RIGHT(A1,1)))*1
  Column E   =(CONCATENATE(MID(A1,2,1),RIGHT(A1,1),LEFT(A1,1)))*1
  Column F   =(CONCATENATE(RIGHT(A1,1),LEFT(A1,1),MID(A1,2,1)))*1
  Column G   =(CONCATENATE(RIGHT(A1,1),MID(A1,2,1),LEFT(A1,1)))*1

    The formulas can be on a different page as long as the "A1" points to your Number "026".

    DrDan
  
• Rakster

  

  Saskatchewan
  Canada
  Member #19,991
  August 9, 2005
  2,960 Posts
  Offline
  Jul 19, 2007, 9:58 am

  ▲▼
  In response to DrDan

  Quote: Originally posted by DrDan on Jul 19, 2007

  Rakster,
     Not sure what you're asking for concerning the Charts but this is what I did.

  Column A   026

  Column B   =(CONCATENATE(LEFT(A1,1),MID(A1,2,1),RIGHT(A1,1)))*1
  Column C   =(CONCATENATE(LEFT(A1,1),RIGHT(A1,1),MID(A1,2,1)))*1
  Column D   =(CONCATENATE(MID(A1,2,1),LEFT(A1,1),RIGHT(A1,1)))*1
  Column E   =(CONCATENATE(MID(A1,2,1),RIGHT(A1,1),LEFT(A1,1)))*1
  Column F   =(CONCATENATE(RIGHT(A1,1),LEFT(A1,1),MID(A1,2,1)))*1
  Column G   =(CONCATENATE(RIGHT(A1,1),MID(A1,2,1),LEFT(A1,1)))*1

    The formulas can be on a different page as long as the "A1" points to your Number "026".

    DrDan
  

  Thank you Doc... this is exactly what I was looking for!

  We are all Lucky... just some of us don't realize it!
  
  
• Just6ntlc

  United States
  Member #16,611
  June 2, 2005
  3,493 Posts
  Offline
  Jul 19, 2007, 1:57 pm

  ▲▼

  I hope that combination hits.
• DrDan

  

  Trenton, Missouri
  United States
  Member #48,844
  January 11, 2007
  2 Posts
  Offline
  Jul 19, 2007, 8:57 pm

  ▲▼

    What I said:
    Not sure what you're asking for concerning the Charts but this is what I did.

  Column A  026

  Column B  =(CONCATENATE(LEFT(A1,1),MID(A1,2,1),RIGHT(A1,1)))*1
  Column C  =(CONCATENATE(LEFT(A1,1),RIGHT(A1,1),MID(A1,2,1)))*1
  Column D  =(CONCATENATE(MID(A1,2,1),LEFT(A1,1),RIGHT(A1,1)))*1
  Column E  =(CONCATENATE(MID(A1,2,1),RIGHT(A1,1),LEFT(A1,1)))*1
  Column F  =(CONCATENATE(RIGHT(A1,1),LEFT(A1,1),MID(A1,2,1)))*1
  Column G  =(CONCATENATE(RIGHT(A1,1),MID(A1,2,1),LEFT(A1,1)))*1

    The formulas can be on a different page as long as the "A1" points to your Number "026".

   

  What I should have said!!

  
   Format columns A thru G as "Custom '000'".

  Column A  Lottery draw  026

  Column B  =CONCATENATE(LEFT(A1,1),MID(A1,2,1),RIGHT(A1,1))
  Column C  =CONCATENATE(LEFT(A1,1),RIGHT(A1,1),MID(A1,2,1))
  Column D  =CONCATENATE(MID(A1,2,1),LEFT(A1,1),RIGHT(A1,1))
  Column E  =CONCATENATE(MID(A1,2,1),RIGHT(A1,1),LEFT(A1,1))
  Column F  =CONCATENATE(RIGHT(A1,1),LEFT(A1,1),MID(A1,2,1))
  Column G  =CONCATENATE(RIGHT(A1,1),MID(A1,2,1),LEFT(A1,1))

    The formulas can be on a different page as long as the "A1" points to your Number "026".

  Sorry for the confusion. Hope this helps.

  DrDan