Hello Jacko,

If you are calculating combinations then the formula is nCk. Where n i
number of objects, 42 in your case, and k is the number of groups (
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 Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48468