EXCEL find adn delete

[Templar]

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.

 

[Peo Sjoblom]

Tag them then examine them, then delete

http://www.cpearson.com/excel/Duplicates.aspx

--


Regards,


Peo Sjoblom

 

[Templar]

Could you be a little more specific as to how to do this?

 

[Bob I]

Please read the instructions at the link provided by Peo.





Could you be a little more specific as to how to do this?