Does anybody know how to compute a running best quarter (3 months) and year (12 months)?
So, if I've got data that spans over 5 years on a monthly basis and I wanted to know what my best and worst consecutive 3/12 month segments were, what formula would I use?
Thanks