Sort Routine VBA
Thanks Arno,
Ok the expected result in that case would be the following:
A B
--- ---
1 2
3 4
5 6---------
4 5
1 6
2 3---------
2 5
3 6
1 4---------
1 3
2 4---------
4 6
3 5---------
2 6
1 5---------
Notice that at Combination 1 - 3, I can only pair up only matches per round
I suggest you look at my other post "Need a Special Sort Routine" i think it
is more clear
Thanks,
w
"arno" wrote:
Hi,
pls. post the result you're looking for.
arno
I have two columns, I would like to sort out the following so that
for every
set of 3 rows (starting at top) the values from Column A and B don't
repeat
themselves.
A B
--- ----
1 2
1 3
1 4
1 5
1 6
2 3
2 4
2 5
2 6
3 4
3 5
3 6
4 5
4 6
5 6
|