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
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