Checking for duplicate records / rows

[Hru48]

Hey all,

Right, here's my problem - I have a spreadsheet with thousands o
records and I need to check to see iff any of them are duplicated.

In column A I have a ZIP codes which are sorted into ascending order
so can anyone think of a way of checking through this column to see i
any one zip matches the zip above it or below it?

Many thanks,

Hayle

 

[Paul B]

Hayley, have a look here for ways to do it,

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Hru48]

Thanks a bunch :