One way ..

Assume duplicates to be checked on col A's data,
where data is in row2 down

In say, E2:
=IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,"x",""))
Copy down to last row of data in col A. This flags duplicates with "x".
Then apply autofilter on col E, choose: x
Select the filtered rows (select the blue row headers)
Right click Delete Rows Done!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mcpa" wrote:
I need to know how to remove duplicate rows from access or excel when only
one column has duplicates.. I don't care about the other field, I just need
to keep the first one it finds. \

thanks