Find latest date based on a product code

Occasional Contributor

Hello

 

I Need the formula for finding latest date based of a UPC in a separate table 

 

so below is example, i want column D to show the latest date (in this case this is a customer review tracker) in a separate workbook (below in pic 2) based on the product code in column A in the 1st book and link to column I to show the latest date in the second book 

 

By the way both workbooks are separate documents 

 

cmckernan93_0-1646659681712.png

 

cmckernan93_1-1646659869917.png

Thanks, Kind Regards 

 

1 Reply

Hi @cmckernan93 

You can use MAXIFS. In the example I have put the tables on the same sheet but you can change workbook after typing =maxifs( and select the dates and product codes from the other workbook before you finally select the (black) product codes.

 

bosinander_0-1646678201942.png

Cell F19

bosinander_1-1646678369638.png

I assume you have done some changes in the example columns and thus adjusted to a column with dates. 

Deeper description of MAXIFS eg at https://exceljet.net/excel-functions/excel-maxifs-function