Quickly locating duplicate records

[Guest]

I have a large merged list of member records from different sources. There are two important fields -- member number and email address. I need to identify duplicate records and eliminate both exact duplicates and duplicates where one key field is the same but the other is not -- i.e., I have to make a determination of which record is most accurate. I can eliminate the exact duplicates using the advanced filter, but it is the other type that is problematic.

After sorting on member number and email address, is there a way to find duplicate pairs (using first one field and then the other) so I can choose which I wish to delete? The list is 50,000 records long so it is not practical for me to do this manually, row by row.

I'm trying to complete this project asap, so if you can help I'd appreciate if you'd also directly email me at (e-mail address removed).

Thanks!

 

[Myrna Larson]

Assuming your duplicates are in column A, try a "helper" column with this
formula: =COUNTIF($A$2:$A$50000,A2"), Then Auto Filter on this column to show
records with values greater than 1. Deciding which record to keep may be
easier if you sort on the relevant column first, so the duplicates are
adjacent.

I have a large merged list of member records from different sources. There

are two important fields -- member number and email address. I need to
identify duplicate records and eliminate both exact duplicates and duplicates
where one key field is the same but the other is not -- i.e., I have to make a
determination of which record is most accurate. I can eliminate the exact
duplicates using the advanced filter, but it is the other type that is
problematic.

After sorting on member number and email address, is there a way to find

duplicate pairs (using first one field and then the other) so I can choose
which I wish to delete? The list is 50,000 records long so it is not
practical for me to do this manually, row by row.

I'm trying to complete this project asap, so if you can help I'd appreciate

if you'd also directly email me at (e-mail address removed).