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.

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)

"Brenda" wrote in message
...
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.

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" wrote:

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)

"Brenda" wrote in message
...
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.

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)

"Brenda" wrote in message
...
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" wrote:

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)

"Brenda" wrote in message
...
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.