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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"PMST" wrote:
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?