Duplicate cells

[Richard Mahan]

I have an excel spreadsheet of approximately 1500 Names,addressses etc.
there are many duplicate cells of which I want to delete the duplicates and
I am looking for the best way to accomplish this.

I am new to excel and using formulas but if there is a way to use color to
point out the duplicates, that would be very helpfull, thanks

 

[Pete_UK]

You could try to use Advanced Filter to get rid of the duplicates.
Ensure that you have headers in row 1 (Name, Address_1, Address_2 etc)
and highlight all the data including the headers. Then click Data |
Filter | Advanced Filter and in the pop up click Unique Records only.
Click OK and your list will be reduced.

This may not get rid of them all - if you have a Mr A Smith, Antony
Smith, Tony Smith etc who all live at the same address, these will be
treated as unique records. Similarly, if you have 21 High St and 21
High Street, these will not be recognised as being the same address.

Hope this helps.

Pete

 

[Guest]

ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.

Incidently, this is exactly the answer I gave to a posting just a few days
ago. You can often find answers to your questions by searching in the forum
-- also easy as pie: Just type a key word like "duplicates" in the search box
above.