Is it Possible for Excel to Do something like ths?

Reply #4

DrDan — Fri, 20 Jul 2007 00:57:07 GMT

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... [ More ]

Reply #3

Just6ntlc — Thu, 19 Jul 2007 17:57:17 GMT

I hope that combination hits.

Reply #2

Rakster — Thu, 19 Jul 2007 13:58:18 GMT

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

Reply #1

DrDan — Thu, 19 Jul 2007 10:07:15 GMT

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... [ More ]

Is it Possible for Excel to Do something like ths?

Rakster — Tue, 17 Jul 2007 14:13:58 GMT

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