View Single Post
Old 04-01-2020, 04:09 PM
GraemeSS GraemeSS is offline Windows 10 Office 2019
Join Date: Apr 2020
Posts: 6
GraemeSS is on a distinguished road
Default Find % change from last month automatically updated

Hi Gurus,
I want to know percentage change from last month (C6-D6)/C6. But I want it to be displayed in a column at the end and to automatically update each time I add the monthly data.

I'm using offset to find the latest data


How do I combine them to find the latest percentage change from last month each time I add new data.

I am not the greatest whiz at Excel but here is how I solved the rolling 12 months average.

=IFERROR(AVERAGE(OFFSET(B6,0,COUNTIF(C6:AF6,">.00" ),1,-12)),"")

Would love to hear from you in these dark days.
Reply With Quote