excel

[Guest]

Hi,
I have a set of numbers through out the sheet.
May be the number is repeated 4 times in the worksheet.

Is there any method without find and replace.
To locate those values.

Thanks in advance!!!
Rajendra

 

[Guest]

Say the data is in A1 thru B10. Select the cells and pull-down:

Format > Conditional formatting > Formula Is >

=COUNTIF($A$1:$B$10,A1)>1 and pick a nice distinctive background

All the duplicates will be hi-lighted

 

[Steve G]

Say the data is in A1 thru B10. Select the cells and pull-down:

Format > Conditional formatting > Formula Is >

=COUNTIF($A$1:$B$10,A1)>1 and pick a nice distinctive background

All the duplicates will be hi-lighted

Dear Gary's Student,

I tried what you stated. It worked for each column. But if the same
number was in column A once and in column B once, it did not show up
as a duplicate by the conditional formatting.

Steve G

 

[Dave Peterson]

It's time to share the formula you used.

Dear Gary's Student,

I tried what you stated. It worked for each column. But if the same
number was in column A once and in column B once, it did not show up
as a duplicate by the conditional formatting.

Steve G