Try this sequence on a copy of your data sheet ..
Insert a new col B
Put in B2: =IF(COUNTIF(A$2:A2,A2)1,"x","")
Copy B2 down to the last row of data in col A. This flags duplicates as "x".
Kill the formulas in col B with an "in-place" copy n paste special as values.
Put a label into B1, apply autofilter on col B, choose: "x" from the dropdown
in B1. This gives you all the duplicate rows to be deleted. Select all the
filtered rows (select all the blue rowheaders), right-click Delete Row.
Done.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"sahafi" wrote:
I have a data list on 10 columns. I'd like to fitler and remove the the
duplicates based on col A only. Advance filter will filter single col. How
can I keep unique codes on col A and remove all the duplicates codes in colA
along with the rest of the records on the other 9 colunms?