ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Power Pivot Variance Column (https://www.excelbanter.com/excel-discussion-misc-queries/450000-power-pivot-variance-column.html)

[email protected][_2_]

Power Pivot Variance Column
 
How do I get the difference between two columns. I want to calculate a variance column (Current Period)-(Prior Period) The periods column headers are not dates, but p01....p12. etc. for the current year and p01Y....p12Y for the prior year"


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com