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