Share

Excel Help

Avatar

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

msmusic's avatar - music note-t10469-2jvmir1.jpg

=mod(a1-1,10)  copy the cell over to other column 

Then copy downward

Avatar
In response to msmusic
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

Avatar
In response to msmusic

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?

Avatar
In response to AllenB

Thanks AllenB

Todd's avatar - Cylon 200.jpg

<Moved to Lottery Discussion forum>

Please post in the appropriate forum ... thank you.

TopEnd of thread (1 page)

Welcome Guest

Your last visit: Fri, Nov 27, 2020, 11:19 am

Log In

Log InCancel

Forgot your username?

Forgot your password?