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)
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)