HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IN A WORKSHEET CONTAINING 1000 NOS HOW CAN I CHECK IF THEIR ARE ANY SIMILAR
NUMBERS
 
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Worksheet 1
i WANT TO CALCULATE THE NO IN A SINGLE COLUMN WHICH ARE NOT SAME. 1
How do i match simillar data between two different rows in excel? 3
Filter similar contact numbers. 1
checking for a string & No. 10
Red cell for negative numbers in Excel 1
Count based on Conditions 1
A "spell check" for numbers 2

Back
Top