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
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
No comments:
Post a Comment