change the last 0 in the formula to ""

as you can see from the link included the MAX(IF portion of the formula is an array formula
when you enter a 'normal' formula into a cell you just hit Enter for Excel to accept it
with an array formula you have to hit Shift+Ctrl+Enter all at the same time for Excel to accept it as an array formula
and Excel will automatically add the { and } to the formula.

drag down... click and hold on that little square in the lower right corner of the cell and pull it down the column to copy the formula to those cells


Hope that helps.