• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count unique values based on multiple criterias

Status
Not open for further replies.

samantha

New Member
have a data sheet of 3 columns

ID Number | Depot | Passed Yes/No
12345 East y
45561 West y
12345 East y
33654 North y
12345 East n
62321 South n
62321 South n
52183 East y
I would like to return a count of how many people at Depot passed eg if I choose South it should give me a return of 1 (it should not count the same id number twice but only once.

if I want to see how many people passed at Depot East it should return a value of 2 (even though we have 4 entries for depot east, id number 12345 passed twice but it should count as 1)
 
Status
Not open for further replies.
Top