Last Edited By **Krjb Donovan** **Last Updated:** Mar 05, 2014 09:19 PM GMT

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.

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

Advertisement

©2024 eLuminary LLC. All rights reserved.