Deleting Duplicate Records

[marionmccaleb]

I have a long list of names some of which are duplicated once---I want to delete the records of both of these names (not just one which the Filter function will do). How can I do this?

 

[marionmccaleb]

I want to add a closing note to this successful endeavor. I finally received two lists of names (and their associated records)---I copied these two lists to a worksheet with a total of 10,381 records. When I did the run (which took less than a minute) I got some surprising (but correct ) results---there were dupicates in the first list (unexpected) but no duplicates between the lists (also unexpected). Thanks HalfAce for providing the code which made this possible, and thanks also to Anne, Erik, and Chearn for your helpful suggestions---warm regards, Marion

 

[HalfAce]

Hi Marion,
Thanks for the feedback. Glad to hear it worked out as desired.
"Less than a minute" seems like a long time (roughly the life span of a
Bohemian mountain goat in terms of code execution) but I guess it still
beats going cross-eyed or blind going through 10K + records manually.