A cool next step after that would be to know which cell contained that max value, because I would love to grab a related value from that same row (I'm thinking OFFSET helps with finding the related value in the same row of the cell with max date).
I tried this and it fails:
Code: Select all
=MAX(IF($A$5:$A$20=E16;A5:A20))