jeudi 1 novembre 2018

Excel Percentile Array Formula for Values within Date Range

I'm trying to find the 90th percentile of values within a date range. I'm currently using this array formula:

{=PERCENTILE(IF(AND(E2<Combined_clean!F$2:F$220828,C2>=Combined_clean!F$2:F$220828),Combined_clean!J$2:J$220828),0.9)}

in which E2 is the lower bound for the date range, C2 is the upper bound, F2:F220828 within the Combined_clean sheet is the date values of the data, and J2:J220828 is the data values. Every time I try to run this I get a "#Value!" error. What am I doing wrong?

Aucun commentaire:

Enregistrer un commentaire