Wednesday, February 6, 2013

yogi_Extract the Unique Locations And The Name Of The Person Who Travels To The Location Most


                                          Google Spreadsheet   Post  #1014
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 06, 2013
post by user: a good friend of mine said:(http://productforums.google.com/forum/?zx=jkl1wboolo4r#!category-topic/docs/spreadsheets/docs-community/desktop/isqDvj71nUw)
Extract the Unique Locations And The Name Of The Person Who Travels To The Location Most 

Basically I want to query through all of my data and get unique Locations along with the name of the person who goes each location most and how many times they go there.

So Gill went to St. Louis twice and Teresa only went once...so I only want to see Gill's name and the number 2

If there are people tied for that location I would like the message "more than one" and "N/A" to appear respectively
---------------------------------------------------------------------------------------------------------

following is a convoluted solution as partial response to the question