Find % change from last month automatically updated

GraemeSS

New member
Joined
Apr 2, 2020
Messages
3
Reaction score
0
Points
0
Excel Version(s)
Microsoft 365
Hi Excelling 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

OFFSET(B6,0,COUNTIF(C6:AF6,">.00"))


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.
Graeme
 
My apologies for unlinked cross posts

cross posted without links:
https://www.msofficeforums.com/excel/44689-find-change-month-automatically-updated.html
where it's me that has responded to your question

GraemeSS, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

Hi, my apologies for the unlinked cross posts. This makes sense. Will add links next time.

Here is another link. https://chandoo.org/forum/threads/f...-from-last-month-automatically-updated.43974/
 
Try

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=(OFFSET($B6,0,COUNTIF($B6:$AF6,">0")-1)-OFFSET($B6,0,COUNTIF($B6:$AF6,">0")))/OFFSET($B6,0,COUNTIF($B6:$AF6,">0")-1)[/FONT]
 
Try

=(OFFSET($B6,0,COUNTIF($B6:$AF6,">0")-1)-OFFSET($B6,0,COUNTIF($B6:$AF6,">0")))/OFFSET($B6,0,COUNTIF($B6:$AF6,">0")-1)

Hi Bob, thanks for helping me. I have had to move on to other more pressing tasks. Will get back to you when I come back to this.
 
Back
Top