I have a sheet with reporting periods as columns and each row having a separate metric. Please see image (the yellow part).
I want to calculate the variance with respect to the previous month for all the rows,
i.e. Jan-17 (Sales - Variance) = Jan-17 (Sales) - Dec-16 (Sales)
which in this case is 100 - 94 = 6!
But I want to be able to do it for 6 cells and not type the formula out in each cell separately.
I'm happy to try out any other approaches to this issue that anyone can suggest too.
Any help would be greatly appreciated!
Thanks in advance,
Please sign in to leave a comment.