Re: Managing duplicates with the advanced filter

Hi,

I just had a go at this. I can get it to work when I use "advanced
filter" to filter the list "in place". For the range, choose just the 3
columns you want to examine for duplication. No criteria are needed.
Check unique records only.

This will hide the rows containing duplications, but not delete them.
You can then copy the visible rows (and all of your columns) to another
location (another work*** so as to avoid the hidden rows).

Hope it works for you!

Jim

gwh@xxxxxxxxxxxxxxxxxxxxxxx wrote:
Hi everyone,

I need some help removing duplicates from a very large customer
database in a spread***. I need excel to delete the row if there are
rows where the customer firstname and surname and also the address1
columns are identical. I tried the following without success:

I went into the Advanced Filter dialogue, I chose the "copy to another
location" radio button and also ticked "unique records only". I entered
Y1 as the cell where the duplicates would be copied to and then I
entered a criteria range. I just clicked on the first cell at the top
of the columns that I wanted to be my criteria columns, ie. firstname,
surname and address1. When I clicked OK it did copy a whole heap of
data that were obviously dupliates but it didn't delete the duplicates
from the original list, it only copied them to the specified cell
location.

I'm not even sure if you can do what I want to do but if anyone has any
tips I'd be grateful. Not sure if I'm doing the criteria procedure
properly.

Thanks for any help offered.

.