Sign up for our free Insiders program and get the example file: exceloffthegrid.com/insiders File Reference for this video: 0232 Quick Variance Analysis
@@ExcelOffTheGrid Oh, I know the techniques. The problem is, other people don't know these techniques, and I am left dealing with their poorly setup spreadsheets.
The # and Tables are different. Tables expand with data (i.e. the raw inputs), while the # expands based on the calculations on the table. You need to use both together.
This is great if you have reports coming in on an expected cadence, but I’m wondering if you have a solution to do this same thing with previous versions of the file on SharePoint through its past history of updates for 1 wk/1 mo/1 yr?