How to Find MAX value with depedency

  • Thread starter Thread starter jeff.potts
  • Start date Start date
J

jeff.potts

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
 
Are you trying to say that you only want to consider the value if it has a
false value in the same row. Can you explain a little more.
 
Yes I only want the maximum value where is also false such that Column z =
"False" and in the same row for column L find the max value.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to Find Max in a Row and Return Column Title 4
Max Value within filtered range 4
Figuring out MAX LEN in a given column 2
finding the cell adjacent to the max value in a row with formula 4
EXCEL - Meet 2 criteria, then find next case of third criteria 3
How to find max cell location 7
Crrection Help for a macro to locate max value cell 2
Insert columns copied to clipboard results in vaues not forumlas 5

Back
Top