+ Reply to Thread
Results 1 to 3 of 3

Count unique values (conditional)

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Count unique values (conditional)

    Hi there,

    I have a spreadsheet with ID numbers from a database that I would like to count based on specific conditions. In my spreadsheet I have values in column A that represent a volunteer ID, and values in column B that represent a project ID. I would like to have a count of each unique value in Column A, as long as the corresponding values in column B match. I am logging volunteer time sheets into an online database, and I want to count volunteers on each project within the spreadsheet. I have attached a sample workbook. Thanks for your help!
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Count unique values (conditional)

    Counting the unique Volunteer ID:
    =SUMPRODUCT(1/COUNTIF($A$2:$A$33,$A$2:$A$33))
    Quang PT

  3. #3
    Registered User
    Join Date
    04-08-2013
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Count unique values (conditional)

    That works perfectly- thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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