Find latest date based on a product code

Question

Hello&nbsp;I Need the formula for finding latest date based of a UPC in a separate table&nbsp;&nbsp;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&nbsp;&nbsp;By the way both workbooks are separate documents&nbsp;&nbsp;&nbsp;Thanks, Kind Regards&nbsp;&nbsp;

bosinander · Answer

Hi&nbsp;cmckernan93&nbsp;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.&nbsp;Cell F19I assume you have done some changes in the example columns and thus adjusted to a column with dates.&nbsp;Deeper description of MAXIFS eg at&nbsp;https://exceljet.net/excel-functions/excel-maxifs-function

Forum Discussion

Find latest date based on a product code

1 Reply

Resources