In Access, you can use a Find Duplicates query. In Excel, Chip Pearson has a bunch of stuff
about them at www.cpearson.com
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"mcpa" wrote in message
...
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