Wednesday, October 31, 2012

yogi_Extract The First Instance Of Most Occurring Candiate In Different Columns To Meet Specified Criteria


                                           Google Spreadsheet   Post  #840
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 31, 2012
user Spring79 said: (http://productforums.google.com/forum/?zx=gdxpen6jynp#!category-topic/docs/spreadsheets/PNwQUW8C-2U)
Need help counting occurences

I'm making a google spreadsheet with some statistics and need some help couting some results. Theres 3 things I want to do. I will show an example:
ex.

Col1 Col2 Col3
1978  A  Mike
1991  A  Pete
1978  B  Mike
1984  C  Bob
1985  B  Brad
1978  A  Tom
Count how many different occurences in Col2 where C1= 1978
Result = 2
Count most reoccuring in Col2 where C1= 1978
Result = A
Show which person occurs the most in Col3 where C1= 1978
Result = Mike
Thanks in advance
--------------------------------------------------------------------------------------------
following is a solution to the problem