Delete rows with duplicated values
 

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

Delete rows with duplicated values
 

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,








Thank you for your help.

Mike

"Emece" wrote:

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

Delete rows with duplicated values
 

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

Mike wrote:

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,








Thank you for your help.

Mike

"Emece" wrote:

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

--

Dave Peterson