https://www.lotterypost.com/thread/183550 Lottery Post Forum Topic: Excel help needed... en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/183550/1143693 https://www.lotterypost.com/thread/183550/1143693 Tue, 28 Oct 2008 02:20:34 GMT Rakster This is so cool!

Thank you for everything!

Wow

]]> Rakster https://www.lotterypost.com/thread/183550/1143536 https://www.lotterypost.com/thread/183550/1143536 Mon, 27 Oct 2008 23:41:43 GMT time*treat 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

]]> time*treat https://www.lotterypost.com/thread/183550/1143132 https://www.lotterypost.com/thread/183550/1143132 Mon, 27 Oct 2008 12:55:15 GMT Rakster Thanks

]]> Rakster https://www.lotterypost.com/thread/183550/1143001 https://www.lotterypost.com/thread/183550/1143001 Mon, 27 Oct 2008 02:40:36 GMT time*treat 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

]]> time*treat https://www.lotterypost.com/thread/183550 https://www.lotterypost.com/thread/183550 Sun, 26 Oct 2008 16:36:26 GMT Rakster 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 i... [ More ]

]]> Rakster