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:

https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Hgm7WIc9wPI

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

---

https://docs.google.com/spreadsheets/d/1csmW1xbgeS8UHV-cqlXlF43FYpgYhWZjPBMV5QGr4YE/edit?usp=sharing

Hope this helps!

Barb