I have two leaves with the same columns. I need only one query to extract the most recent matching record from each of the two sheets. Here, I will simply show them as adjacent beaches:
| Stu | Date | Type | Commentary | | ------ | ------------ | --------- | ----------------- | | Bill | 28/03/2019 | Reading | good job | | Rick | 26/03/2019 | Writing | bad work | | Bill | 14/03/2019 | Reading | ok work | | Rick | 15/03/2019 | Writing | soso work | | Rick | 16/03/2019 | Reading | not good at all | | Bill | 17/03/2019 | Writing | Please try! |
I would like to create a single query that gives me the most recent of each type (1 reading and 1 writing) for each student. (For example, in this example, Bill's most recent comments on reading and writing in the first two rows and Rick's most recent reading and writing comments in the next two rows.)
I've tried some combinations of Group and Limit and Max that have almost worked but not quite.