Return the latest date an event happened
I would like some help to return the latest date an event happened that was hosted by a person.
In one smartsheet I have the data entry table, and another that I'm using as a summary table to reference to for convenience.
For example I'm trying to return.
e.g. 'when was the last date 'Joe Bloggs' hosted an event?' . I would want '28/03/2018' returned in the formula out of the list below:
Joe Bloggs 24/03/2018
Joe Bloggs 25/03/2018
John Jones 26/03/2018
Joe Bloggs 28/03/2018
Vlookup doesn't work for me (unless using it wrong) because it cannot return the latest date value.
Is there some way to find this with a formula?