+ Reply to Thread
Results 1 to 4 of 4

How to count unique/distinct users within a data set

  1. #1
    Registered User
    Join Date
    12-08-2013
    Location
    Michigan, America
    MS-Off Ver
    Excel 2007
    Posts
    16

    How to count unique/distinct users within a data set

    Hi there,

    I'm trying to count the number of distinct users from a data set.

    For example: if I have three teams, team 1, team 2, and team 3 and I have 8 rows of data for team 1, 3 rows of data for team 2, and 1 row of data for team 3 but I can see a user has been entered multiple times on team 1 and team 2. How do I count the number of unique/distinct users for every team?

    Capture.PNG

    Results should be
    Team 1 has 5 unique/distinct users
    Team 2 has 2 unique/distinct users
    Team 3 has 1 unique/distinct users

    I've tried countif formula's but that only gets me a total amount of data point per team and not the number of distinct users. I've also tried a frequency formula but that can't count based on specific teams and only show the frequency of all the data. Not sure if there is a way to merge the two formulas to achieve this goal.

    Also, trying to stay away from array formulas as my spreadsheets can be > 100,000 data points and that makes my Excel crash and staying away from pivot tables.



    Thanks so much!
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,876

    Re: How to count unique/distinct users within a data set

    Have a look here
    https://exceljet.net/formula/count-u...-with-criteria

  3. #3
    Registered User
    Join Date
    12-08-2013
    Location
    Michigan, America
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: How to count unique/distinct users within a data set

    This worked perfectly.
    Thank you.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,876

    Re: How to count unique/distinct users within a data set

    You're welcome & thanks for the feedback

+ 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. Count unique distinct values IF....
    By vwhite in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-27-2020, 01:14 PM
  2. [SOLVED] Count Distinct and SUMIF to find unique text values
    By hilton426 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2017, 08:18 AM
  3. Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  4. [SOLVED] Excel - Count distinct occurences and copy unique values
    By random0munky in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-26-2015, 10:41 PM
  5. Replies: 5
    Last Post: 03-13-2012, 06:05 AM
  6. Count of distinct (unique) values by day
    By velorian in forum Excel General
    Replies: 7
    Last Post: 12-06-2011, 05:03 PM
  7. Pivot Tables-To Find Count of Unique(Distinct)User id within the same Journal Entry.
    By Deepthik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2010, 06:09 AM

Tags for this Thread

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