Combination of 6 numbers from a range of cells, which may contain up to 19 random numbers - no duplicates

[jag108]

Hi There,

I have read a few of the posting about lotto number generations, I have a slightly different twist on this subject.

I am evaluating a series of number based on history and some calculations, from that I will select my own hot and cold numbers into a list.
What I am trying to do is generate combinations of 6 numbers based on my list of numbers.

I may select a list of 15 numbers, or I may select a list of 20 numbers this is all dependent on what I select.

So if i choose this range of numbers how can I generate combinations of 6 from this list, without duplicate combinations of 6.

1​

3​

5​

8​

11​

14​

21​

22​

24​

27​

29​

31​

32​

35​

37​

13​

17​

 

[jag108]

Did it fulfill your needs?

Thank you Sir, yes it did perfectly

 

[johnnyL]

Cool. Glad to help.