Hi, i know by the formula =combin(49,6) how many combination of 6 numbers there are from a available 49 numbers (13983816).
how do i manage to get all combinations listed in a excel spreadsheet? I would want the numbers in individual cells. For example, Row 1 would show 6 numbers individually from A1 - F1.
I do realise that excel does not have enough rows to do this so may have to continue on other sheets.
As you may have guessed i am doing something on the lottery numbers and also would want it to generate a bonus number in column G.
Formulas in excel as oppose to excel VB code is preferred.
Many thanks.
Bookmarks