find duplicated lines in excel sheet

[Alan]

I have an excel sheet with text column. I wish to find and remove some
duplicated lines.

How can I do it? If I can do it with Excel?

I've tried google for this task and found freeware tool for finding
duplicated - http://www.aks-labs.com/support/phpBB2/viewtopic.php?t=69
it was good for my task, but if I can do something better with Excel?

Thank you!

 

[Barb Reinhardt]

You could use conditional formatting for the column with duplicates.


http://www.contextures.com/xlCondFormat03.html#DupColumn

 

[Jack Marks]

Nah. Your best bet is to just make a pivot table. That will remove the
extra lines. If you don't know how to make a pivot table., Jack says you
MUST learn. You will thank me, bless my children, wish me eternal
happiness, etc.