Re: Duplicate cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Richard Mahan wrote:
I have an excel spread*** 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

.

Quantcast