Delete rows with duplicated values

E

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.-
 
Top