Non array alternative for percentile function

Hello experts:

I wanted some help getting rid of array equations.

I have a worksheet with named ranges: Month, Week, Machine, and Data. Here is how I currently use the percentile function:

{=PERCENTILE(IF(N(Month="Jan")*N(Week=2)*N(Machine="M1"),Data),0.5)}

This works fine; however, since I have multiple equations like the one above, excel slows down quite a bit.

Can anybody suggest a better alternative?

Unfortunately, I can not upload my data file, but I have created a dummy file with the above equation for you to see - if needed.

Attachment 157302

Thank you in advance.

You don't really need N function, possibly very slightly better would be

=PERCENTILE(IF(Month="Jan",IF(Week=2,IF(Machine="M1",Data))),G1)

but to save time perhaps use a helper column, e.g. in your example try concatenating the three columns in to 1, e.g. in E2 copied down

=A2&"-"&B2&"-"&C2

then your percentile formula can be

=PERCENTILE(IF(E1:E135="Jan-2-M1",Data),G1)

Thank you for the tips, daddylonglegs.

So I assume you do not see a way to get away from array formula?

There are versions that don't need CTRL+SHIFT+ENTER......but I don't think they will help with speed if that's your main concern......