Checking for duplicate records / rows
 

Hey all,

Right, here's my problem - I have a spreadsheet with thousands of
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 if
any one zip matches the zip above it or below it?

Many thanks,

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=516720

Checking for duplicate records / rows
 

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

http://www.cpearson.com/excel/duplic...tingDuplicates

--
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" wrote in
message ...

Hey all,

Right, here's my problem - I have a spreadsheet with thousands of
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 if
any one zip matches the zip above it or below it?

Many thanks,

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=516720

Checking for duplicate records / rows
 

Thanks a bunch :)


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=516720