Welcome Guest
You last visited January 20, 2017, 7:01 am
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
Member #19992
August 9, 2005
2867 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!

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

Member #19992
August 9, 2005
2867 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.

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

 Page 1 of 1