How to get largest date from a Vlookup

  • Thread starter Thread starter Madiya
  • Start date Start date
M

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

Kindly help.

Madiya
 
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
Click to expand...

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


Regards
Claus B.
 
Back
Top