Hi,

As you can see below, I have some data as below. Now I would like to find
the latest date for each name. May I ask which formula I can use? The result
I want is
Anne - 2008/3/6, Bryan - 2008/6/7...etc. Thanks in advance.

Anne 2008/11/5
Anne 2008/1/15
Anne 2008/3/6
Bryan 2005/1/1
Bryan 2006/5/1
Bryan 2007/5/31
Bryan 2008/6/7
Cody 2001/8/1
Cody 2002/9/30
Cody 2006/7/8
Cody 2007/9/6
Cody 2008/8/15
David 2009/3/1
David 2009/5/1