How to get largest date from a Vlookup

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
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top