+ Reply to Thread
Results 1 to 2 of 2

Looking for count of unique numbers, not total count of all number (if that makes sense)

  1. #1
    Registered User
    Join Date
    06-25-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    13

    Looking for count of unique numbers, not total count of all number (if that makes sense)

    I'm looking to identify the number of machines that had issues within any given month. The serial number appears in the raw data each time there is a single issue. So if SN 001 has 3 issues in March 2018, it's on 3 separate lines. If I do a Pivot table, under March 2018 (if SN 001 was the only machine with errors) it will show as a count of 3. Is there a way to change the settings of the pivot table so it will identify the count per discrete number....so in this example, it would return a value of 1 (because SN 001 was the only machine with an errors in March), rather than 3?

    I've attached a file which may help to make more sense....this one is a little difficult to describe. Sorry!!!

    Any help would be really appreciated!!!

    Thanks!

    Amy
    Attached Files Attached Files
    Last edited by 6StringJazzer; 10-05-2018 at 01:10 PM. Reason: You need unique numbers, not discrete numbers. Title updated by Moderator.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Looking for count of unique numbers, not total count of all number (if that makes sens

    Try this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    It's an array formula. Close with [Ctrl]+[Shift]+[Enter].
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] To count total numbers recorded by group total
    By michael35 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-03-2018, 08:12 AM
  2. [SOLVED] Function possible for Using specific number to count other specific numbers total ?
    By Karnik in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-02-2015, 03:35 AM
  3. Replies: 6
    Last Post: 12-22-2012, 05:04 PM
  4. [SOLVED] Count the total number of times several numbers appear on each row
    By dwontheweb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-28-2012, 12:11 AM
  5. Hope this makes sense...
    By mckoy_1 in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 09-20-2006, 03:21 AM
  6. How do i count numbers and letters to find a total count of all
    By Linda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2005, 12:55 PM
  7. [SOLVED] Number count - postcodes and need to count the numbers of tim...
    By Mark - Aust in forum Excel General
    Replies: 1
    Last Post: 10-24-2005, 05:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1