How to get largest date from a Vlookup
 

I have following data amongst other columns.
Product Date
aaa 2014-02-11
aaa 2014-02-12
aaa 2014-02-03
aaa 2014-01-22
bbb 2013-01-17
bbb 2014-01-23
bbb 2014-01-28
bbb 2014-01-06
bbb 2013-01-28

In another sheet, I need to search product and get the largest date against that product.
Formula result required is as below.
aaa 2014-02-12
bbb 2014-01-28

Kindly help.

Madiya

How to get largest date from a Vlookup
 

Hi,

Am Fri, 14 Feb 2014 01:42:26 -0800 (PST) schrieb Madiya:

I have following data amongst other columns.
Product Date
aaa 2014-02-11
aaa 2014-02-12
aaa 2014-02-03
aaa 2014-01-22
bbb 2013-01-17
bbb 2014-01-23
bbb 2014-01-28
bbb 2014-01-06
bbb 2013-01-28

In another sheet, I need to search product and get the largest date against that product.
Formula result required is as below.
aaa 2014-02-12
bbb 2014-01-28

try:
=MAX(IF(Sheet1!A1:A100=A1,Sheet1!B1:B100))
and enter the array formula with CTRL+Shift+Enter


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2