Find most recent date for ID with multiple records in Excel sheet
Solution 1:
Try this array formula -
=MAX(IF(A2=Sheet2!$A:$A,Sheet2!$C:$C))
An array formula must be entered with ctrl + shift + enter and show curly brackets {} around it.
Try this array formula -
=MAX(IF(A2=Sheet2!$A:$A,Sheet2!$C:$C))
An array formula must be entered with ctrl + shift + enter and show curly brackets {} around it.