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

With the name in cell C1 use the below formula. Format formula cell to date...

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

=MAX(IF((A1:A100=C1),B1:B100))

If this post helps click Yes
---------------
Jacob Skaria


"lalann" wrote:

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

Fantastic! Many thanks.

"Jacob Skaria" wrote:

With the name in cell C1 use the below formula. Format formula cell to date...

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

=MAX(IF((A1:A100=C1),B1:B100))

If this post helps click Yes
---------------
Jacob Skaria


"lalann" wrote:

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