I need some urgent help. I need to find the number of unique agencies below for number 1, but I need to exclude the agency named "HUMA" from the results. In this case, the answer would be 1(ie. Agency SOAP). What's the formula to do so? Assume the column "Number" is column A and column "Agency" is column B.
Number Agency
1 SOAP
2 BALL
1 HUMA
2 NIJA
2 POIS
1 SOAP
Thank you!
Bookmarks