I'd like to search a spreadsheet for a name, and pick out the most recent date next to it if possible please? My data looks a little like:
| Name | Date |
|----------------|------------------|
| Sally | 04/06/2017 |
|----------------|------------------|
| Tim | 12/04/2018 |
|----------------|------------------|
| Sally | 16/09/2019 |
|----------------|------------------|
| Sally | 29/02/2018 |
In this case, I'd like to return 12/04/2018
for Tim, and 16/09/2019
for Sally.
Is this possible please?
Update: still struggling with this formula:
=ARRAYFORMULA(SORT(VLOOKUP(QUERY(
{ROW(Events!A2:A), SORT(Events
!A2:D)},
"select max(Col1) where Col2 <> '' group by Col2 label max(Col1)''", 0),
{ROW(Events!A2:A), SORT(Events!A2:D)},
{2, 3},
0), 1, 0))
The dates are Events!A
and the names are Events!D
for what it's worth.
29/02/2018
is not a valid date