View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default EXCEL find adn delete

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