Skip to main content
Question

Rolling Median

  • 4 October 2023
  • 1 reply
  • 246 views

Hi all,

 

I know it’s possible to calculate rolling averages and rolling windows using formulas, but has anyone come up with a formula for calculating a rolling median? Something like FREQPERCENTILE(A, .5), but applied over various durations.

 

— Matt

i’d also love to be able to do this!


Reply