Combination query.

Question

Respected

Suppose, I wish to make a matrix of 25 numbers which I have to choose from the range of 01 to 75 numbers, every column should have 5 combinations out of 15 numbers each. For e.g.; The 1st column should have combinations of numbers from 01 to 15, 2nd column from 16 to 30, 3rd from 31 to 45 & so on¡­¡­ There are 3003 such combinations possible {=combin(15,5)}. To elaborate my query, kindly go through the following example.

1 16 31 46 61 2 17 32 47 62 3 18 33 48 63 4 19 34 49 64 5 20 35 50 65

2 20 32 47 62 3 21 33 48 63 4 22 34 49 64 5 23 35 50 65 6 24 36 51 66

& so on¡­¡­¡­¡­¡­

Waiting for your possitive reply.

Thanking You

With Mayur Lakhani.

Answer

The answer I gave at

http://en.allexperts.com/q/Excel-1059/combinations-2.htm

will basically give you what you want - the macro will need minor modifications to handle the numbers you want, but basically is the one you need - let me know if you need help to modify it - if it helps, my email is aidan.heritage@virgin.net