Monday, February 6, 2012

yogi_Extract Details Of The Most Recent Game Played From Data In Different Spreadsheets

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

user jkelley said:
Show only the most recent date in a spreasheet
Ok here is something kind of crazy. I have multiple different sheets that contain scores for sports games in the following format.
Date, @/vs, Opponent, Score
The first 3 columns are pre-filled at the beginning of the season and the score field updated as we go. The different sheets are all embedded in a webpages for public use. Now what I want to do is have the latest score show up in a separate sheet combining all the sheets together. For instance when I update the score today the "summary page" shows the new score I just added and the latest scores from the other sports.
Any thoughts?
following is a solution to the problem ... where I have merged the data from different spreadsheets and then queried the data for the most recent game actually played