https://www.lotterypost.com/thread/317425 Lottery Post Forum Topic: Excel Help, Transposing random sets into sequential order en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/317425/5381007 https://www.lotterypost.com/thread/317425/5381007 Fri, 29 Dec 2017 18:15:27 GMT RL-RANDOMLOGIC I had to look up what CRS stood for, LOL. Don't feel alone

RL

]]> RL-RANDOMLOGIC https://www.lotterypost.com/thread/317425/5379703 https://www.lotterypost.com/thread/317425/5379703 Thu, 28 Dec 2017 15:23:22 GMT Johnebench BINGO, I used to be able to do that back in the 80's but I'm in full blown CRS now. Thanks for the help.

]]> Johnebench https://www.lotterypost.com/thread/317425/5379702 https://www.lotterypost.com/thread/317425/5379702 Thu, 28 Dec 2017 15:19:46 GMT Johnebench I see Excel has it too. Thanks Mr.B

]]> Johnebench https://www.lotterypost.com/thread/317425/5379639 https://www.lotterypost.com/thread/317425/5379639 Thu, 28 Dec 2017 14:08:28 GMT JADELottery Select all the cells with the data.

Press ALT then D then S. (does not have to be upper case)

Excel should come up with a dialog for sorting.

]]> JADELottery https://www.lotterypost.com/thread/317425/5379356 https://www.lotterypost.com/thread/317425/5379356 Thu, 28 Dec 2017 04:17:00 GMT Mr-B 216 I don't have Excel, but in Open Office there is a built in sort function. Select the range of cells to sort and then go to the menu Data Sort.

I'm sure Excel should be similar.

]]> Mr-B 216 https://www.lotterypost.com/thread/317425 https://www.lotterypost.com/thread/317425 Thu, 28 Dec 2017 02:23:46 GMT Johnebench Take P3 P4 combos and re-arrange them in numerical order.

From To

this this

258 036

470 066

440 161

455 208

699 258

694 208

695 258

396 290

927 396

928 440

496 455

703 470

036 496

696 520

400 550

550 694

814 695

066 696

661 699

161 661

964 703

290 758

975 769

976 814

970 927

769 928

758 970

208 975

520 976

]]> Johnebench