Sunday, May 3, 2015

yogi_Pull Latest Entry For Each Candidate For Each Day From Form_Responses Sheet (sorted in descending order by Timestamp column)


                                           Google Spreadsheet   Post  #1952
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    May 03, 2015
post by Barb Reinan:
Filter one response per day per person using time stamp and person's name
I am using this formula to filter responses from a form on another sheet within the same workbook. I am trying to pull one response per day per person, using the last response of the day. The formula works well for a few people and then breaks down, skipping people or dropping people from the sheet with the filtered responses. Does anyone know what is breaking?

=filter('Form Responses 4'!A:A, match('Form Responses 4'!A:A, query('Form Responses 4'!A:B, "select max(A) group by toDate(A), lower(B) label max(A) 'Timestamp'",1), 0))

Let me know if more information is necessary!


Barb
---