+ Reply to Thread
Results 1 to 4 of 4

Count Unique text based on multiple conditions

  1. #1
    Registered User
    Join Date
    10-13-2003
    Posts
    27

    Count Unique text based on multiple conditions

    I'm not sure this is even possible, but here's what I am trying to do. I want to count the number of unique occurrences based on multiple criteria


    Name Title Task Week Hours
    Joe Smith Manager Meetings 5/13/05 50.00
    Jane Doe Assistant Meetings 5/13/05 10.00
    Jane Doe Assistant Administration 5/13/05 30.00
    Jenny Dee Assistant Meetings 5/13/05 00.00
    Jim Jones Assistant Work Papers 5/13/05 20.00

    What I want to do here is return the unique count of "Assistants" that booked "Hours" for "Week" 5/13/05. The answer is 2

    Any help would be greatly appreciated!
    Thanks,
    Max
    Last edited by MAX258; 05-13-2005 at 12:02 PM.

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Try Data>Filter>Autofilter then choose your criteria from each column, you'll end up with only two records showing.

    HTH

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

  3. #3
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Another way...

    =SUM(IF(FREQUENCY(IF((B2:B6="Assistant")*(D2:D6=DATE(2005,5,13))*(E2:E6>0),MATCH(A2:A6,A2:A6,0)),ROW(INDIRECT("1:"&ROWS(A2:A6)))),1,0))

    ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

    Hope this helps!

  4. #4
    Registered User
    Join Date
    10-13-2003
    Posts
    27

    It works!

    Dominec,

    It worked!! Thank you so very much. I would have never figured that out on my own.

    Thanks again.


    thanks also Bruce.

    Max

+ 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