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.

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 you
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 on
adjacent lines. Once you are at this point you can either chop out the
duplicate or build a macro to do the same thing

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=401065