Hi.

I have a workbook in Excel 2007 with several phone numbers. If the numbers
are duplicated I applied a conditional formatting so as to display them in
red, using the following formula: =COUNTIF($A:$A,$A2)1. Additionally if the
value is repeated I need to delete one of the rows. Which is the best way to
do this?

Thanks in advance

Regards
Emece.-