How to extract the latest form responses of each emails with formula?-CodePudding

Input

Timestamp	Email	Answer Field
2022/07/01 00:00:00	[email protected]	1st of A
2022/07/02 00:00:00	[email protected]	1st of B
2022/07/03 00:00:00	[email protected]	1st of C
2022/07/04 00:00:00	[email protected]	2nd of A
2022/07/05 00:00:00	[email protected]	2nd of B
2022/07/06 00:00:00	[email protected]	3rd of A

Output

Timestamp	Email	Answer Field
2022/07/03 00:00:00	[email protected]	1st of C
2022/07/05 00:00:00	[email protected]	2nd of B
2022/07/06 00:00:00	[email protected]	3rd of A

Formula preferred (one or more):

ArrayFormula, QUERY, FILTER

CodePudding user response：

Please use the following

=QUERY(A77:C85,"select max(A), B, max(C) where A is not null 
                group by B order by max(A)
                label max(A) 'Timestamp', max(C) 'Answer Field' ",1)

(do adjust the formula according to your locale and ranges)