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.