Tag them then examine them, then delete
http://www.cpearson.com/excel/Duplicates.aspx
--
Regards,
Peo Sjoblom
"Templar" wrote in message
...
I've got a 7 column EXCEL sheet. I want to eliminate duplicate entries.
The
problem is that I need to locate duplicate last names in one column and
then
examine the entries in each line before deleting one of the lines.
Is this possible? Or do I have to go down each record manually?
Thank you.
--
Templar