Results 1 to 5 of 5

Thread: Find % change from last month automatically updated

  1. #1
    Neophyte GraemeSS's Avatar
    Join Date
    Apr 2020
    Posts
    3
    Articles
    0
    Excel Version
    Microsoft 365

    Find % change from last month automatically updated



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,706
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://www.msofficeforums.com/excel...y-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

  3. #3
    Neophyte GraemeSS's Avatar
    Join Date
    Apr 2020
    Posts
    3
    Articles
    0
    Excel Version
    Microsoft 365

    My apologies for unlinked cross posts

    Quote Originally Posted by p45cal View Post
    cross posted without links:
    https://www.msofficeforums.com/excel...y-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/fi...updated.43974/

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,771
    Articles
    0
    Excel Version
    O365
    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. #5
    Neophyte GraemeSS's Avatar
    Join Date
    Apr 2020
    Posts
    3
    Articles
    0
    Excel Version
    Microsoft 365
    Quote Originally Posted by Bob Phillips View Post
    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
  •