Search results

WOW!! Haseeb, that's some insane work on that sheet. It's pretty close to what I need so I should be able to tweak it a bit to get the results I require. I'm not sure what some of the formulas mean but I'm working on figuring out. Thanks again for all your help.

Hello Narayank991 - It can be any 3 consecutive months. Same for the year. Hui - I wont be able to upload a file due to the sensitive nature of the data. If it's required I can try and work around it though. Thanks for the help guys. Farouk

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