Wednesday, July 11, 2012

yogi_Pull Latest Info From Form Data By Last And First Name With Additional Specified Condition(s)

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #619   Jul 11, 2012

user bryan-p said:(!category-topic/docs/spreadsheets/CwRFGzP_2uw)
Using Query() to show updated info
Can I use a Query() to show the most updated info in this sheet?  The expected results are right below.  If a user submits the form but leaves one of the fields blank, that blank field shouldn't be included - only the most recent responses from Question 1 and 2.
I know the formula I'm using in A1 of Current Info sheet is just pulling everything from Form Data sheet.
=QUERY('Form Data'!A:E;"select C, B, D, E, max(A) group by B, C, D, E order by max(A) desc label max(A) 'Last Updated' ";1)

The 3 rows of data as presented in the user's spreadsheet were too few to develop a solution, so I added several more rows as presented in my the following