Find the maximum date using lookup when there are multiple entries with different dates

[GeorStu]

Hello I would like to ask the following.

I have a list of ProductIDs and their Date of Sale. Each ProductID can have multiple DateOfSale.

My data looks like this:
ProductID Date Of Sale
1 23/01/2020
1 23/02/2020
1 23/03/2020
2 23/01/2020
2 23/02/2020
2 23/03/2020
3 23/01/2020
3 23/02/2020
3 23/03/2020

I have tried this:
VLOOKUP(A2,$A$1:$B$10,2,0)

Any suggestions please?
Thanks

[Paul]

Hi GeorStu, try this out:

Please Login or Register  to view this content.

Where B1:B10 has your dates, A1:A10 has your Product ID's and C1 has the Product ID you're trying to find the max date entered.

[GeorStu]

Thanks for the reply.
Unfortunately, my excel version does not support MAXIFS function

[Paul]

Then try this array formula. After typing (or editing) this formula, you must use CTRL+SHIFT+ENTER instead of just ENTER. When you do this properly, Excel will automatically add braces, { }, around the formula. Do not add those braces yourself, as it will not work.

Please Login or Register  to view this content.