+ Reply to Thread
Results 1 to 4 of 4

Count Without Duplication Multiple Criteria

  1. #1
    Registered User
    Join Date
    01-26-2016
    Location
    St. Louis, USA
    MS-Off Ver
    Office Mac 2016
    Posts
    2

    Count Without Duplication Multiple Criteria

    Hello,

    I have a scenario where multiple people can work on the same work item, which belongs to a project.

    I'd like to be able to count the total number of items being worked on within a workstream, ignoring duplication.

    I've gone through the forums and I've tried many pivot tables and sumproduct() type solutions, and I cannot get there...

    Any help is appreciated.

    Thank you!
    deDuplicate_with_criteria.xlsx
    Screen Shot 2016-01-26 at 5.05.02 PM.png
    Last edited by chadmott; 01-26-2016 at 07:06 PM. Reason: added screenshot

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Count Without Duplication Multiple Criteria

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    where $C$2 is: CoolProj, OK Proj, WTFProj
    Confirm by CSE (Control+Shift+Enter)


    sandy2chadmott-deDuplicate_with_criteria.xlsx
    Last edited by sandy666; 01-26-2016 at 11:02 PM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    01-26-2016
    Location
    St. Louis, USA
    MS-Off Ver
    Office Mac 2016
    Posts
    2

    Re: Count Without Duplication Multiple Criteria

    thanks @sandy666 this is great!

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Count Without Duplication Multiple Criteria

    Glad to help

    Thank you for rep and feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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