I have a dynamic Chart that uses the last 12 cells in column using:
This gets the last 12 months of data from column C. works great!
Is there a formula that I can get the previous 12 months? so I can make another chart that compares both years?
Excel Formula:
=OFFSET(Sheetname!$C$2,COUNT(Sheetname!$C:$C),0,-13,1)
This gets the last 12 months of data from column C. works great!
Is there a formula that I can get the previous 12 months? so I can make another chart that compares both years?
Last edited by a moderator: