Array Formula with multiple conditions to same column

Question

Array Formula with multiple conditions to same column

Anonymous

Hello

I've recently learned that excel also has array formulas.

I am using the following array formula:

{=QUARTILE(IF(B:B=1,IF(C:C="A",IF(D:D="MAF3",E:E))),1)}

My question is as follows...

I want to add additional conditions to column D. For example, MAF3, MAF4 AND MAF5 at the same time.

How do I accomplish this in the current formula?

Thank you so much

Kind regards

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Hi.

Welcome to the world of ARRAY formula. First off ARRAY formula are slow and particularly so if as you have done and use full columns. So avoid the use of full columns. In this formula I've cut it down to 15 rows, use more if you need to but only use sufficient to catch all your data.

=QUARTILE(IF(B1:B15=1,IF(C1:C15="A",IF(ISNUMBER(MATCH(D1:D15,{"MAF3","MAF4","MAF5"},0)),E1:E15))),1)

Remember CTRL + Shift + Enter

Share via

Array Formula with multiple conditions to same column

0 additional answers