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