use helping column

In Cell B2 put this formula and drag it down

=IF(A2=A1,"duplicate","unique")

use filter to delete the duplicate


On Feb 12, 6:01*pm, Emece wrote:
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.-