Forum Discussion
Find latest date based on a product code
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 track...
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.
Cell F19
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