Find % change from last month automatically updated

ArviLaanemets · #2 04-01-2020, 11:04 PM

Here you go!

There are 3 variations of same formula. In 2nd one I replaced subformulas of 1st one with dynamic Names, to make the formula on sheet more readable. The 3rd one is copy of 1st one, but it uses dynamic Named Ranges as source instead on Table (it's for case you don't want to use defined Tables).

You can replace month number in current format with date of 1st of month, and format it then in any way too. But remember, the values you use for months must grow in right order! (I.e. texts like "January 2020" and "February 2020" will not do.)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LINK field path will be updated automatically	bynkook	Word	1	02-28-2020 02:54 AM
change formula based upon change of month	invgrp2	Excel	7	05-03-2018 10:46 AM
How to get data updated automatically without show this message?	LearnerExcel	Excel Programming	2	02-12-2018 08:20 PM
Can i automatically add a debit on the first of every month?	Taras49	Excel	2	06-16-2015 12:54 PM
How can references be updated automatically?	ezthelm	Word	2	05-30-2011 03:45 AM