LARGE IF Functions Within A Table

[warrevar]

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 the table, however it's just not working.  Here is the formula I'm using:

{=LARGE(IF( [7]=[1], [36]),1)}

A couple of other notes:

• All of the examples of this function I have seen show it OUTSIDE of the table, not WITHIN the table.  This makes me wonder if it's even possible to accomplish this with the LARGE/IF functions within a table or if maybe there's another way to do it(?)
• I have tried it both as an array and non-array formula, but without success.

[#2]

@warrevar 

Try this:

[#3]

@Patrick2788, that's essentially what I have.  However, I want the formula to be applied to a column within the table like so...

[#4]

@warrevar 

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.

[#5]

@Patrick2788,

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. 

[#6 · Accepted solution]

@warrevar 

That makes sense. I've attached a sample that resembles your data.

[#7]

@Patrick2788 

It appears to be what I had, only now it works!  Thanks!