Hi, The question is for our lotto syndicate:

The numbers range 1 to 49 with a drawn set of 6 numbers:

In any set of of six numbers there a

246,820 combinations that contain 3 of the six numbers drawn

13,545 combinations that contain 4 of the six numbers drawn

252 combinations that contain 5 of the six numbers drawn

How can I generate the the 252 - 5 of 6 number combinations from the 6
numbers?
and the 3 and 4 out of six.

In effect there will be 252 sets of 6 numbers generated which 5 of the
drawn numbers.
(In seperate cells please)

I had a look at Myrna Larsons code combinations/permutations (now
thats clever!)
and trawled through lots of past posts by such as Tom Ogilvy and Myrna
Larson
but cannot find what I want to see:

Thanks very much for any help/pointers

Ste