use Donna said:
I am trying to compute the number of unique Advertisers (Column B, Sheet "Client List") booked to attend an event (= "Y" in Column P, Sheet "Client List") for each sales rep (Column A, Sheet "Client List").
My expected result for sales rep "Anthony Fonseka" would be 3 (02 PLUS SDN BHD, ACE SYNERGY INSURANCE BHD,TERRADERM SDN BHD)
and result of 1 for sales rep "Kevin Choong" (ONLYONE ZUZA FOODS INDUSTRIES SDN BHD).
Note that Advertisers TERRADERM SDN BHD & ONLYONE ZUZA FOODS INDUSTRIES SDN BHD occur twice but should only be counted once.
I hope that makes sense
Thanks a lot