filtering rows BUT order of columns does not matter

hey everybody!

I have a table of values that represent the connections of some neurons.
but in this table each connection is saved as send AND receive connection.
so if A and B are connected, I have two etries in my table:
A B
B A

what I want to do is to get rid of one of these two entries. but I do not know how - all the posts that I found around the internet only say how to delete duplicate entries like
A B
A B

can someone please explain to me how to get rid of duplicate rows where the order of the colums does not matter (like I described in the example above)?

thanks,
Johannes

Assuming columns A & B have the data:

1) Put this formula in C1 and copy the cell down the whole dataset:
=A1&"-"&B1

2) Put this formula in D1 and copy down:
=B1&"-"&A1

3) Put this formula in E1 and copy down:
=COUNTIF($D$1:$D1,$C1)


A series of 0s and 1s (and possibly more) will appear.

4) Sort the entire set of data A:E descending by column E. This will put the dupes at the top.

5) Select all the rows with 1 and delete them all at once.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.