Finding repeated data in a excel spreadsheet

[excel novice!]

I have a problem with an excel spreadsheet that i need help with...
I am studying a road network and it is represented by points (nodes) and the
space inbetween these is the road.
My problem is that obviously a road goes from say point A to point B but
also back the way from point B to point A. The data i have contains both data
from point A to point B but also from point B to point A. This data is
identical and to i'd like to delete the repeated data from B to A. The
problem is that point A may go to up to 5 other locations, ie to B,C,D,E or -
as roads do at a junction. Therefore there is a fair amount of repeated data
that i can see no way of deleting easily.

Can anyone help?

Calum.

 

[Jon Quixley]

Calum
Save the original spreadsheet and make a copy before doing anything!

I think that you can do this by sorting the data by the values. As yo
say the data for the road between A and B and B and A is identical
therefore if you sort this, you should endup with the duplicates o
adjacent lines. Once you are at this point you can either chop out th
duplicate or build a macro to do the same thing

Cheers
Jo