An array formula that must be entered using ctrl+shift+enter
=MAX(IF(G9:G14="john",F9:F14))

--
Don Guillett
SalesAid Software

"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