Thread: most recent date (correction)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
excelFan excelFan is offline
external usenet poster
  
Posts: 53
Default most recent date (correction)
many many thanks Don

"Don Guillett" wrote:

Sorry, I have NO knowledge of excel mobile

--
Don Guillett
SalesAid Software

"excelFan" wrote in message
...
works fine in pc,
but not on excel mobile it returns 00-Jan-00 all times
many thanks

"Don Guillett" wrote:

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







Reply With QuoteReply With Quote