Welcome Guest
Log In | Register )
You last visited October 23, 2017, 1:12 pm
All times shown are
Eastern Time (GMT-5:00)

Is it Possible for Excel to Do something like ths?

Topic closed. 4 replies. Last post 10 years ago by DrDan.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Thread Starter
Saskatchewan
Canada
Member #19992
August 9, 2005
2887 Posts
Offline
Posted: July 17, 2007, 10:13 am - IP Logged

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!

    Avatar
    New Member
    Trenton, Missouri
    United States
    Member #48846
    January 11, 2007
    2 Posts
    Offline
    Posted: July 19, 2007, 6:07 am - IP Logged

    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's avatar - praying hands.jpg
      Thread Starter
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2887 Posts
      Offline
      Posted: July 19, 2007, 9:58 am - IP Logged

      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!


        United States
        Member #16612
        June 2, 2005
        3493 Posts
        Offline
        Posted: July 19, 2007, 1:57 pm - IP Logged

        I hope that combination hits.

          Avatar
          New Member
          Trenton, Missouri
          United States
          Member #48846
          January 11, 2007
          2 Posts
          Offline
          Posted: July 19, 2007, 8:57 pm - IP Logged

            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