I want to return the maximum value in a column of data;
"=MAX(Tasks!L5:INDEX(Tasks!L:L,COUNT(Tasks!L:L)+1) )"

However, I am trying to make the value dependant upon it also having a
value of False in Column "Z". Otherwise choose the next value that
meets the criteria.

Any ideas on this one? I'm Stumped

Jeff