Duplication

P

PMST

I'm running a Pivot Table to show all duplicate entries in my spreadsheet.
Is there a way for me to automatically remove those dupicate entries without
manually going back in and removing them one at a time?
 
M

Max

One simple way to flag & remove duplicates ..
Assume source data in A2 down
In B2: =IF(A2="","",IF(COUNTIF(A$2:A2,A2)>1,"dup",""))
Copy B2 down to the last row of data in col A. Then apply autofilter on col
B, filter for: dup. Select and delete these filtered rows (the dups), remove
autofilter
 
Top