So, let's say I have 2 rows of data with 10 columns. (or 10 rows and 2 columns, whichever is easier) What I want to do is list all combinations of groups of 5 selected from different columns. So, if my data looked like this (with one combination included in red):
never have an Ax and Bx in the same combination. Is there a macro that can output all those combinations in a 5 column arrangement?
Code:
A1 A2 A3 A4 A5 A6 A7 A8 A9 A10
B1 B2 B3 B4 B5 B6 B7 B8 B9 B10
0 commentaires:
Enregistrer un commentaire