# Thread: Find % change from last month automatically updated

1. ## Find % change from last month automatically updated

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

https://www.msofficeforums.com/excel...y-updated.html
where it's me that has responded to your question

This is a requirement, not just a request.
Why? Have a read of http://www.excelguru.ca/content.php?184

3. ## My apologies for unlinked cross posts

Originally Posted by p45cal
https://www.msofficeforums.com/excel...y-updated.html
where it's me that has responded to your question

This is a requirement, not just a request.
Why? Have a read of http://www.excelguru.ca/content.php?184

4. Try

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

5. Originally Posted by Bob Phillips
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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•