Non repeating combinations in Excel

[alancardoso]

Guys,

is there any way to obtain non repeating combinations in Excel?

Ex: I have 15 numbers in cells A2 to O2 (with A2=1, B2=2, ... O2=15).

Iīm trying to make Excel write to cells A3 to O3 non repeating combinations.
Order doesnīt matter.

However, the number of cells populated do matter.
So, for example, I would like to obtain in A3 to O3
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
1 2 3 4 5 6 7 8 9 10 11 12 13 14
1 2 3 4 5 6 7 8 9 10 11 12 13 15
1 2 3 4 5 6 7 8 9 10 12 13 14 15
and so on.


The idea is that every time Excel writes A3 to O3 the new combination I would have another macro using this values, so:

(if Iīm correct)

1) It would need to be a loop

or

2) I would need to have all combinations pasted in cells (the first combination in A3:O3, the second combination in A4:O4, and so on).

Thanks for the help!

[shg]

Please take a few minutes to read the forum rules about cross-posting.

Thanks.

[alancardoso]

I didnīt know that.

In order to comply with the forum rules, here is the link for the other post.

http://www.mrexcel.com/forum/excel-q...ml#post3575205

[shg]

Thank you.