Forum Discussion

warrevar's avatar
warrevar
Brass Contributor
Jan 14, 2020
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 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.

6 Replies

    • warrevar's avatar
      warrevar
      Brass Contributor

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

       

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor

        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.

Resources