Welcome Guest
You last visited March 25, 2019, 5:09 pm
All times shown are
Eastern Time (GMT-5:00)

# Excel help needed...

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

 Page 1 of 1
Member #19991
August 9, 2005
2925 Posts
Offline
 Posted: October 26, 2008, 12:36 pm - IP Logged

Can anyone tell me if its possible to formulate a cell where I have a pair of numbers.. say 51 and I want to add a digit from the previous days draw to it...

Example... I have pair 51... last nights draw 280

I want to formulate it so I get 512, 518 and 510

I also want to get it so it would give me 251, 815, 015 and 521, 581 and 501

So what I am asking is if its possible to formualte a set number "280" where each of its digits can go independantly into the pair where ever I would like it placed.

I play straights and use about 30 pairs so this is the reason for asking for a formula.

Any help wpuld be greatly appreciated.

Thanks

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

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: October 26, 2008, 10:40 pm - IP Logged

In A1 format:

formulas
 A B C D E 1 pair draw 1st 2nd 3rd 2 51 280 =A2&MID(B2,1,1) =A2&MID(B2,2,1) =A2&MID(B2,3,1) 3 45 951 =A3&MID(B3,1,1) =A3&MID(B3,2,1) =A3&MID(B3,3,1)

yields:

results
 A B C D E 1 pair draw 1st 2nd 3rd 2 51 280 512 518 510 3 45 951 459 455 451

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

Member #19991
August 9, 2005
2925 Posts
Offline
 Posted: October 27, 2008, 8:55 am - IP Logged

In A1 format:

formulas
 A B C D E 1 pair draw 1st 2nd 3rd 2 51 280 =A2&MID(B2,1,1) =A2&MID(B2,2,1) =A2&MID(B2,3,1) 3 45 951 =A3&MID(B3,1,1) =A3&MID(B3,2,1) =A3&MID(B3,3,1)

yields:

results
 A B C D E 1 pair draw 1st 2nd 3rd 2 51 280 512 518 510 3 45 951 459 455 451

Thanks!!

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

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: October 27, 2008, 7:41 pm - IP Logged

A1 format ...

 A B C D E F 1 type pair draw 1st 2nd 3rd 2 51X 51 280 =B2&MID(C2,1,1) =B2&MID(C2,2,1) =B2&MID(C2,3,1) 3 5X1 51 280 =MID(B3,1,1)&MID(C3,1,1)&MID(B3,2,1) =MID(B3,1,1)&MID(C3,2,1)&MID(B3,2,1) =MID(B3,1,1)&MID(C3,3,1)&MID(B3,2,1) 4 X51 51 280 =MID(C4,1,1)&B4 =MID(C4,2,1)&B4 =MID(C4,3,1)&B4

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

Member #19991
August 9, 2005
2925 Posts
Offline
 Posted: October 27, 2008, 10:20 pm - IP Logged

A1 format ...

 A B C D E F 1 type pair draw 1st 2nd 3rd 2 51X 51 280 =B2&MID(C2,1,1) =B2&MID(C2,2,1) =B2&MID(C2,3,1) 3 5X1 51 280 =MID(B3,1,1)&MID(C3,1,1)&MID(B3,2,1) =MID(B3,1,1)&MID(C3,2,1)&MID(B3,2,1) =MID(B3,1,1)&MID(C3,3,1)&MID(B3,2,1) 4 X51 51 280 =MID(C4,1,1)&B4 =MID(C4,2,1)&B4 =MID(C4,3,1)&B4

This is so cool!

Thank you for everything!

Wow!!

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

 Page 1 of 1