most recent date (correction)
 

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

most recent date (correction)
 

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

most recent date (correction)
 

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

most recent date (correction)
 

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

most recent date (correction)
 

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

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

most recent date (correction)
 

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