Tags: containing, excel, microsoft, msdn, nos, numbers, sheet, similar, software, worksheet

HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET

On Microsoft » Microsoft Excel

1,524 words with 2 Comments; publish: Fri, 23 May 2008 18:41:00 GMT; (306140.63, « »)

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

NUMBERS

All Comments

Leave a comment...

  • 2 Comments
    • 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

      #1; Fri, 23 May 2008 18:42:00 GMT
    • 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" <JLatham.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:4C479625-5B9C-4A71-8F29-165692BE688F.excel.todaysummary.com.microsoft.com...

      > 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

      #2; Fri, 23 May 2008 18:43:00 GMT