+ Reply to Thread
Results 1 to 3 of 3

Count Distinct Values with Multiple Criteria

  1. #1
    Registered User
    Join Date
    07-08-2013
    Location
    Pensacola, FL
    MS-Off Ver
    Excel 2010
    Posts
    7

    Count Distinct Values with Multiple Criteria

    I have a large dataset with many employee names. I am trying to count the distinct dates based on employee for a specific date range. Some names will have many entries for the same date, so I want to know the number of days within a month that have entries. I can manipulate this with a pivot table but I need it to be with a formula. In the spreadsheet you will see I entered the results I want for each employee in D through H.
    Attached Files Attached Files
    Last edited by AliGW; 06-25-2020 at 01:24 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Count Distinct Values with Multiple Criteria

    Please try at F3

    =COUNT(1/FREQUENCY(IF(($B$2:$B$23>=$D3)*($B$2:$B$23<=$E3)*($A$2:$A$23=F$2),$B$2:$B$23),$B$2:$B$23))

    confirm by ctrl+shift+enter
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-08-2013
    Location
    Pensacola, FL
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Count Distinct Values with Multiple Criteria

    Bo_Ry that works perfectly, thank you!

+ 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 distinct values based on two criteria
    By Manikandan Arumugam in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2020, 09:09 AM
  2. Count Distinct Values With A Criteria In A Filtered List
    By JonnyBoy333 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2019, 02:52 AM
  3. Sum column and count distinct values in another based on multiple criteria
    By mike.greene in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-12-2015, 11:50 AM
  4. Count distinct values that correspond to a criteria
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 04-22-2013, 01:03 PM
  5. Replies: 5
    Last Post: 03-13-2012, 06:05 AM
  6. Excel 2007 : Count distinct using multiple criteria
    By ExcelinginSeattle in forum Excel General
    Replies: 2
    Last Post: 12-17-2009, 02:26 PM
  7. Count distinct values with criteria
    By greencardioid in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-29-2008, 06:48 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1