Delete rows with duplicated values

[Emece]

Hi.

I have a workbook, in Excel 2007, that has a column displaying phone
numbers. If the numbers are repeated I need to display them in red text which
I solve with the following formula in conditional formatting:
=COUNTIF($A:$A,$A2)>1
Aditionally, when the value is repeated I need to delete the row. Which is
the best way to do this? A macro perhaps?

Thanks in advance

Regards
Emece.-

 

[Mike]

I have a similar problem.

If a list contains a thousands of email address, which may be duplicated.
How can I easily to find the repeated email address?

For example,

Email addrss,

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Thank you for your help.

Mike

 

[Dave Peterson]

Chip Pearson has lots of techniques for working with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx