Row data duplicate check.

[Matt Carter]

I have a couple copies of a file that I want to verify that they're the same.
I have rows of data that are the same except for a line or two that might
have been forgotten on one.
It is an address book and some people have moved and so the address I have
is in the EXACT same format for the columns, however, their address would be
either not there or different.
I don't know if it's asking too much to find duplicates and mark them as
such and then I can delete them or if it finds duplicates and then deletes
the non original, or leaves one.

Thank you.
Matt

 

[GoBow777]

Hello Matt:

This should help you out. You can also click the Topic Index button at
the bottom of the web page and lookup Duplicate listed under D for more
info.

http://www.cpearson.com/excel/Duplicates.aspx

Matt