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]

There's a workbook that will do this at https://app.box.com/s/b9b9fc06beb63b9562f9

 

[alancardoso]

There's a workbook that will do this at https://app.box.com/s/b9b9fc06beb63b9562f9

Thanks! Its perfect.

 

[shg]

You're welcome.