+ Reply to Thread
Results 1 to 5 of 5

Help with unique number count

  1. 09-01-2013, 02:39 AM #1
    1legin
    1legin is offline
    Registered User
    Join Date
    08-28-2013
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    10

    Help with unique number count

    Hi

    I am trying to find out if a number in C4 appears in a row of numbers K4.AD4.
    I have tried using "COUNTIF" but as the list could contain duplicates, this does not give the answer i need.

    Trying to find if a number appears in row range with a count once function.

    Thanks

    Nigel
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-01-2013, 02:59 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Help with unique number count

    In AF4

    =--(ISNUMBER(MATCH(C4,K4:AD4,0)))

    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 09-01-2013, 03:03 AM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Help with unique number count

    AF4 =if(countif(K4:AD4,C4)>0,1,"")

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 09-01-2013, 01:25 PM #4
    1legin
    1legin is offline
    Registered User
    Join Date
    08-28-2013
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Help with unique number count

    Thanks to all the problem is fixed with the help of the 2 replies

    Nigel
    Reply With QuoteRegister To Reply
  5. 09-01-2013, 02:26 PM #5
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Help with unique number count

    Thanks for the reply.

    Glad I could help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count unique number of days
    By Jwildcat in forum Excel General
    Replies: 2
    Last Post: 06-29-2012, 05:34 PM
  2. [SOLVED] Count unique value for each row in a number of Columns
    By rickyilas in forum Excel General
    Replies: 6
    Last Post: 05-23-2012, 09:14 PM
  3. Unique Change Number Count
    By gmfrick in forum Excel General
    Replies: 18
    Last Post: 03-23-2009, 02:44 PM
  4. Count the number of unique records
    By [email protected] in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-08-2006, 03:35 AM
  5. [SOLVED] Count number of Unique values
    By Alan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1