Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #619 Jul 11, 2012 www.energyefficientbuild.com.
user bryan-p said:(http://productforums.google.com/forum/#!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.
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
user bryan-p said:(http://productforums.google.com/forum/#!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
No comments:
Post a Comment