lottery numbers for 1 to 37 ( not contious )

[sylesh]

dear sir i have series of numbers between 1 to 49 lets say 35 numbers say 1 2 4 7 9 11 13 ......48 these consist of different numbers lets say in all i have 36 numbers

i want to know how to get all the lottery combionation of it 1 of 36 numbers ( but not in sequence 1 2 3 4 5 6 7 8 9 10 .... no this way

can any body help

 

[SanjayGMusafir]

You can use SEQUENCE function to generate the whole series. But I wonder you are aware how big the series would be and how long it can take a system to generate the same.

Just by the imagination of enormity and risk of hanging my system, I'm not attempting it...

Among all the results, you have to eliminate the one you quoted - which is in sequential order. Rest shall be valid

BUT, before you attempt use PERMUTATIONA function to understand the enormity of the entire exercise...

=PERMUTATIONA(36,36)-1

shall be the total number of combinations you want excel to generate...

That is the best I can help. I'm not going to attempt or write the entire formula...