So I have a Google Form dumping data into spreadsheet tab form responses 1.
I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot and be sorted by the main column. My progress thus far is
=QUERY('Form Responses 1'!A2:J, "SELECT max(A), B, C, D, E, F, G, H, I, J group by B, C, D, E, F, G, H, I, J")
Unfortunately, this doesn't show only the latest time stamp and for some reason, the query has a weird effect of showing max in the formula cell with a spare row.
Any help would be appreciated.