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


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

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

--
nozzaworld


"muddan madhu" wrote:

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

Emece;226921 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.-

Supposing your range is in one column Got to Data - Filter - Advanced
filter - Check "unique records only" and choose if you want the
resulting place or not - OK


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63085

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


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

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

"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


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