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