• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Max date of each item

Hui

Excel Ninja
Staff member
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
 

Hui

Excel Ninja
Staff member
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
 
Top