Hi,

I have an irritatingly small querie that I'm struggling to write...

I have two columns of data in a table. The data contains letters, numbers
and underscores and also varies in length. The columns are of equal length.

All I want to do is count the number of unique pairs in this data
irrespective of which column the data is in

for example:

Col A           Col B
123A           65B
123A           65B
65B             123A
23VCJ_0      65B

These are only two unique pairs in the above data - the first three rows are
one pair and the fourth row is the second.

Any help is appreciated....Rgds Chris