Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
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
------------------------------------------------------
Have a look at the following solution to the problem ... to see if I have understood you correctly
No comments:
Post a Comment