With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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)
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))