Wednesday, January 18, 2012

yogi_Extract List Of Unique Advertisers That Are Attending By Sales Exec

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

------------------------------------------------------
Have a look at the following solution to the problem ... to see if I have understood you correctly