clever way Roger, this solves the matter
thank you

"Roger Govier" wrote:

Hi

One way, bearing in mind the restrictions of (Mobile Excel)
Insert the name wanted in cell C2
In cell D2
=(B2=$C$2)*A2
and copy down column D as required
In cell D1
=MAX(D2:D100)

--
Regards

Roger Govier


"excelFan" wrote in message
...
please help
(NB : this is for mobile excel which does not support sumproduct
function)
column column
a:a b:b
visit date name
-------- --------
1/25/04 john
07/9/05 jack
12/17/05 smith
8/20/06 john
9/10/06 jack
11/21/06 bob
and so on...
i want a formula to give me the most recent visit date for JOHN for
example
many thanks