I want tool which finds duplicate date in excel 2003

[Guest]

I want to find out duplicate data in my excel work sheet.

 

[RagDyeR]

Look at Chip Pearson's web site, and scroll down to the D's to find a great
many options on working with duplicates.

http://www.cpearson.com/excel/topic.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I want to find out duplicate data in my excel work sheet.

 

[Guest]

Hi Sridhar

You can use conditional formatting to find duplicates. select the first cell
in the column go to format -> conditional formatting. Select formulae is and
give this formulae (the cell selected is B2)

=countif($B$1:$B$100,B2)>1 and then select the format (lets say you set the
pattern to yellow). Now copy the cell and select the entire range and go for
paste special. paste the format in the selected range. The numbers which are
duplicated will be highlighed in yellow.

Regards
Raj

 

[Bob Phillips]

Use conditional formatting, with a formula of

=COUNTIF($A$1:$A1,$A1)>1

--

HTH

RP
(remove nothere from the email address if mailing direct)