With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, June 14, 2012
yogi_Generate A List Of Top Combination Of Locations And People In Descending Order
user kevinhtre said: I have a set of data that lists dates, people, and locations (of which there are a finite number). I am attempting to produce from that a list of the "top X" for each location. So for instance:
1/17/12 John New York
2/13/12 Bob New York
3/1/12 John Dallas
5/1/12 John New York
6/1/12 Bob Dallas
I am trying to produce from that:
New York: John, Bob [ed. note: John first cuz he appeared twice above]
Dallas: Bob, John [or whatever, they both appeared once so it's a tie]
I'm having a devilish time.
Thanks for any help.
I'm able to use a FREQUENCY to create a two-column list of pairs like so: