Results 1 to 19 of 19

Count Unique w/ Indirect Group Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-24-2012
    Location
    Midwest
    MS-Off Ver
    Office 365
    Posts
    122

    Count Unique w/ Indirect Group Criteria

    I want to do a modified version of what is detailed in this ExcelJet post:

    https://exceljet.net/formula/count-u...-with-criteria

    You can see my modification of this example in my attached spreadsheet. Basically, rather than filter by a specific project name as in the ExcelJet post, I want to filter by a specific project group. A project group can contain multiple different projects. When counting the unique name values for Group1, for example, it should include both Alpha AND Omega projects in the consideration. Here are the expected return values:

    Group 1: 4 (Jim, Sandra, Carl, Sue)
    Group 2: 4 (Jim, Carl, Sue, Ayako)

    I am trying to achieve this with an INDEX/MATCH function that returns a specific named range to an INDIRECT function, but I get the N/A# error when I attempt this. Any help would be appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count of Age group with unique customers
    By Rushendra in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2016, 01:21 AM
  2. [SOLVED] Count unique entries based off unique criteria in another column
    By hambly in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-11-2014, 03:33 PM
  3. [SOLVED] Unique Count In Group SubTotal
    By goss in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-17-2014, 12:42 PM
  4. [SOLVED] potential indirect countif: trying to count unique values giving same responses
    By j.farr3ll in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2013, 08:00 AM
  5. Count of unique stores in a group
    By ZealotAssasin in forum Excel General
    Replies: 4
    Last Post: 05-16-2012, 02:10 PM
  6. Count criteria in group entered in one cell
    By PBG4 in forum Excel General
    Replies: 4
    Last Post: 04-20-2010, 10:47 PM
  7. Count Unique within Group
    By Krazy Kasper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2008, 08:56 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