I wouild read the requests something like this:
given a list of 3000 sets of six number lottery numbers, count the
combinations that contain each set of combinations of 2 numbers drawn from 1
to 42. I assume also for 3 and 4.

your formula can be done with the built in worksheet formula for
combinations

=combin(42,6)

In a previous post, Jacko received code that generates combinations.

--
Regards,
Tom Ogilvy


"Leith Ross" wrote
in message ...

Hello Jacko,

If you are calculating combinations then the formula is nCk. Where n is
number of objects, 42 in your case, and k is the number of groups (6
numbers at a time). To calculate the combinations the formula would be:


(42*41*40*39*38*37)/(6*5*4*2*1) = 5,245,786

I don't think 3000 lines is enough space for your combinations.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=484686