https://www.lotterypost.com/thread/334529 Lottery Post Forum Topic: Excel Help en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/334529/6479927 https://www.lotterypost.com/thread/334529/6479927 Sun, 22 Nov 2020 16:17:50 GMT Todd

]]> Todd https://www.lotterypost.com/thread/334529/6479824 https://www.lotterypost.com/thread/334529/6479824 Sun, 22 Nov 2020 13:29:44 GMT scj2574 Thanks AllenB

]]> scj2574 https://www.lotterypost.com/thread/334529/6479823 https://www.lotterypost.com/thread/334529/6479823 Sun, 22 Nov 2020 13:28:57 GMT scj2574 Will this formula put all 3 digits in 1 cell when I copy over to other column or do I put digits in individual cells columns like 1 in A1, 2 in B2, and 3 in C3

]]> scj2574 https://www.lotterypost.com/thread/334529/6479641 https://www.lotterypost.com/thread/334529/6479641 Sun, 22 Nov 2020 06:16:31 GMT AllenB 123

=CONCATENATE(MOD(MOD(MOD(A1-1,10)-1,10)-1,10),MOD(MOD(A1-1,10)-1,10),MOD(A1-1,10))*1

Copy this formula down to get the number of combinations that you want.

Assumes that your staring combination is in cell A1

]]> AllenB https://www.lotterypost.com/thread/334529/6479635 https://www.lotterypost.com/thread/334529/6479635 Sun, 22 Nov 2020 05:40:51 GMT msmusic =mod(a1-1,10) copy the cell over to other column

Then copy downward

]]> msmusic https://www.lotterypost.com/thread/334529 https://www.lotterypost.com/thread/334529 Sun, 22 Nov 2020 03:54:03 GMT scj2574 Can someone please tell me what formula you put in excel to do a minus 111 rundown like this with lottery math no carry over...

123

012

901

890

789

678

567

456

345

234

]]> scj2574