90 Percentile formula for multiple values and multiple dates that vary in count

[B Maccy]

Hello,

I thought it had been a while since I've posted on here, as it turns out I joined in 2019 and have only now just done an intro!

What I am trying to do is to put together a 90 percentile value in the Percentile by date workbook from the date and values that are in the Date and distances workbook. The count of distance values varies for each date, for instance 2022/01/01 has 26 and 2022/01/02 has 19 entries and so on.

I've used the percentile function before and I could put together a percentile for the range manually but the work I am doing covers multiple years. Is there a way of formulaically approaching this to avoid manually doing this?

Regards
B Maccy

[MiNd_HuNT3r]

Use this formula in B3 and drag it:

Please Login or Register  to view this content.

[windknife]

One guess,

Please Login or Register  to view this content.