excel
 

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

excel
 

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

--
Gary''s Student - gsnu200741


"Raj" wrote:

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

to Gary's student regarding conditional formatting flagging duplicates-- excel
 

On Aug 31, 5:22 pm, Gary''s Student
wrote:
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
--
Gary''s Student - gsnu200741

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

to Gary's student regarding conditional formatting flagging
 

It's time to share the formula you used.

Steve G wrote:

On Aug 31, 5:22 pm, Gary''s Student
wrote:
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
--
Gary''s Student - gsnu200741

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