HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET
 

IN A WORKSHEET CONTAINING 1000 NOS HOW CAN I CHECK IF THEIR ARE ANY SIMILAR
NUMBERS

HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET
 

Assuming that all numbers are in column A and begin at row 1 and go down to
row 1000, you could put this formula into a cell on row 1 and extend it down
to the bottom of the list and it will show a value when the number on that
row is in the list more than once:
=IF(COUNTIF(A$1:A$1000,A1)1,COUNTIF(A$1:A$1000,A1 ),"")
Make sure you use the $ symbol in the places I did.

"SALUJA" wrote:

IN A WORKSHEET CONTAINING 1000 NOS HOW CAN I CHECK IF THEIR ARE ANY SIMILAR
NUMBERS

HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET
 

I would use conditional formatting with the formula

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

to highlight them

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JLatham" wrote in message
...
Assuming that all numbers are in column A and begin at row 1 and go down
to
row 1000, you could put this formula into a cell on row 1 and extend it
down
to the bottom of the list and it will show a value when the number on that
row is in the list more than once:
=IF(COUNTIF(A$1:A$1000,A1)1,COUNTIF(A$1:A$1000,A1 ),"")
Make sure you use the $ symbol in the places I did.

"SALUJA" wrote:

IN A WORKSHEET CONTAINING 1000 NOS HOW CAN I CHECK IF THEIR ARE ANY
SIMILAR
NUMBERS