Forum Discussion
Solved
LARGE IF Functions Within A Table
Hello! I am combining the LARGE & IF functions within a column of a table. I want the formula to look for matching parameters within the same table and then give me the largest # for each row in...
That makes sense. I've attached a sample that resembles your data.
Patrick2788, that's essentially what I have. However, I want the formula to be applied to a column within the table like so...
What are the values that should be returned in column AL? I think I know what you're asking but want to be certain. Thanks.
AL should be the largest AK # with a [7] value that equals $A9.
For instance, AL9 should be 1.50. AL10 should be 0.00 because no [7] values = $A10. AL11, 12, 13, etc will also be 0.
That makes sense. I've attached a sample that resembles your data.