LARGE Function with multiple conditions

Hi,

I have created a function as follows:

{=LARGE((IF(AY:AY<>”AAA”,I:I,””)),1)}

This is to return the largest value in column I for any item in AY:AY that isn’t called “AAA”. I used LARGE() because I also want to extract the 2nd, 3rd etc largest values from column I.

This works fine but when I tried to include the condition to also not consider in the ranking any item in AY:AY that’s called “BBB”, using an OR condition, the formula failed.

Can someone please suggest how I can amend my formula.

Thanks!

I don't think you can use OR() or AND() in array formulas. Perhaps try something like:

=LARGE(IF(AY:AY<>"AAA",I:I,0)*IF(AY:AY<>"BBB",1,0),1)

(still as an array formula)

Thank you all!

XOR LX - point taken, thank you

Regards