What is the excel formula to find the invoiced amount for the latest date for a specific contract number and contract line item number (CLIN)? Column A is a list of different contract numbers, Column B is the corresponding CLIN, Column C is the invoiced date and Column D is the invoiced amount. Thanks in advance for the help! I am using MS Office Excel 2013.
