a quick access query for dups will do it. i used to have a saved query like this, but i haven't used it in years.
basically you set up your excel sheet in Access and then run a query against it that shows the unique records based on a field. that is your 'clean' list.
|