HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET

S

SALUJA

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

JLatham

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

Bob Phillips

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)
 
Top