Excel 2002 filtering

[Guest]

I have a list of 16000+ names that includes many duplicates. I used
autofilter which was very helpful in helping me isolate, check and remove
duplicate entries. But, ithe program only allows filtering of the first 1000
or so entries. I tried hiding the first 1400 records that I had already
checked and that worked because it then gave me the next 1000 names. But as
soon as I clicked on a single name to check for duplicates, it goes back to
the original list of A through Chr and loses the rest. Anyone have any tips
or suggestions on how I can filter the complete list without having to cut
the names to a new list? Thanks.

 

[Bob Phillips]

Delete them in line.

Add a simple formula in a helper column, like so

=COUNTIF($A$2:A2,A2)

assuming the key column is A, then copy that down

Filter on this new column for a custom value of > 1 and delete any rows
showing. Then repeat until none show
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob, that was helpful. Unfortunately I have to look at all duplicate
entries for data consistency and correct anything that is missing, then
remove the duplicates. If I was certain that all data was the same it would
have been the perfect solution. I will keep the formula for future use.
Thanks again.

 

[Bob Phillips]

Well this will highlight the duplicates in batches, so you can do that
process and then delete if appropriate.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)