Hi there,

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

Thanks,
w

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

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