Forum Discussion
warrevar
Jan 14, 2020Brass Contributor
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.
That makes sense. I've attached a sample that resembles your data.
6 Replies
- Patrick2788Silver Contributor
- warrevarBrass Contributor
Patrick2788, that's essentially what I have. However, I want the formula to be applied to a column within the table like so...
- Patrick2788Silver Contributor
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.