Delete rows with duplicated values

  • Thread starter Thread starter Emece
  • Start date Start date
E

Emece

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.-
 
use helping column

In Cell B2 put this formula and drag it down

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

use filter to delete the duplicate
 
Hi,

First: Since you are using 2007, when you want to highlight duplicated no
formula is necessary, instead choose Home, Conditional Formatting, Highlight
Cell Ruled, Duplicate Values.

Second: Since you are using 2007, you don't need to create any helper
columns or formulas to remove the duplicates, instead choose Data, Remove
Duplicates.
 
Thanks for your useful reply. After trying it I have one more doubt: what if
I need to delete the entire row for that duplicated value?

Thanks again
Regards
Emece.-
 
I am using excel 2002. I have a row of data, with some duplicated records. I
want to be able to delete ALL duplicates.

e.g.
bob
bob
scott
john

would delete all record of bob leaving just the following:

scott
john

How can I achieve this? Any help will be greatly apprenciated.

Many thanks
 
Back
Top