Alternate Sorting.

[monosij]

Hi,

I have a peculiar situation where I want to sort by. Can anyone give me any pointers please if this can be achieved.

I have the following data

C1	C2	C3
100	141	A
100	142	B
141	100	A
142	100	C

<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>

<tbody>
</tbody>

and this is how i need the data to be displayed after sorting

C1	C2	C3
100	141	A
141	100	A
100	142	B
142	100	C

<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>

If you notice C1 and C2 have the same values but half the list is inverted and I need to be able to bring the rows which have the same combination together. Another complexity is that this needs to be dynamic as it is not necessary that the pairs will always exist and I'm fine for the ones that are not in pairs to be stacked together at the end.

Any help is much appreciated.

 

[par60056]

The values in column 3 do not identify pairs, correct? Can you add a helper column?

If you can add a helper column, put the formula "=MIN(Ax:Bx) & MAX(Ax:Bx)" Then sort on that.