Greetings.
I need help with generating a list of all possible combinations with NO repetitions.
Using a set of 53 numbers, from 1 to 53, no 0.
I need a formula to generate a list combination (6 in a row) with above numbers without repetition.
Can someone please help me with that formula?
No Macros, please.
Thank you in advance.
Formula:
=COMBIN(53,6)
Nearly 23 million!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks