Duplicate records

  • Thread starter Thread starter Sarah Wardle
  • Start date Start date
S

Sarah Wardle

I have a spreadsheet set up for a mail merge but there are
duplicate records that need to be removed.

I can filter the data and take out the duplicate records
leaving only 1 copy of the duplicate, but I need to take
out all occurrences of the record.

Any ideas?
 
Sample: With Firstname in A2 and Last Name in B2 - In Cell C2 I enter =
A2&B2 (to concatenate and get the fullname) then in D2 enter:
=IF(COUNTIF(C$2:C2,C2)>1,"Duplicate","") and copy down to say D100
Then do an auto-filter and on Column D select "Duplicates" - then delete all
currently selected.. Unfilter then and erase Column C and D..
 
Back
Top