Non Array QUARTILE and STDEV IF Formula

Hi everyone,

I'm wondering is there a way of of writing non array formula to calculate the Quartile and Stdev values of a range of data based on the dates of said data

The following formula calculate what I need but since they are array formula and I need the formula repeated for a large number of rows, it slows down excel calc processing too much:

{=QUARTILE(IF((E:E=R10),K:K),3)}

{=STDEV(IF((E:E=R10),K:K))}

Col E contains list of dates
Col R contains date criteria (used for IF condition)
Col K contains values to calculate Quartile & Stdev from

Is there any way of using Index in the same way you might do for calculating the MAX in a non array formula? E.g. =MAX(INDEX(($E$10:$E$5005=$R10)*$K$10:$K$5005,0))

Cheers

Hmm, yea cheers, I resorted to using a workaround solution with a matrix of dates & calcs based and applying just a basic QUARTILE and STDEV formulae for each date row (with values pulled with lookups etc)