Max date of each item

[matt-gilbert]

I need a formula to provide the max date of each item. Formula needs to be in Column C of attached spreadsheet.
Thanks in advance.
Matt

 

[Hui]

If you use the search box at the Top Right of this page and look for Maxif
you may have came across formulas like:
C2: =MAX(IF($A$2:$A$13=A2,$B$2:$B$13,"")) Ctrl+Shift+Enter

Copy down

 

[matt-gilbert]

Thanks Hui. Works great. What if I wanted the last text entry against an item to be shown against all items ie replace all dates with text? Refer attached.

 

[Hui]

D18: =INDEX($C$18:$C$29,MAX(IF($A$18:$A$29=A18,ROW($B$18:$B$29),""))-ROW($A$17),0) Ctrl+Shift+Enter

Copy down

 

[matt-gilbert]

Excellent. Thanks Hui.
Matt