Hello,
I have a PivotTable that displays data by year in columns. It is filtered to display the four most recent years of data. There is a column that calculates the 6 year average off of the most recent 6 years of data which I need to update to get rid of 2009 and add 2015. So I want the formula to be the data from years 2010 through 2015. I'm sure the solution is simple, but I can't figure out how to change the formula for all of the cells in the column besides doing it manually. When I change the first cell of the column manually, it doesn't change the rest of the column. So right now the formula displays =('2012'+'2013'+'2014'+'2009'+'2010'+'2011')/6 and I need to change all of them to =('2012'+'2013'+'2014'+'2015'+'2010'+'2011')/6. Any help would be appreciated.
Thank you.
I have a PivotTable that displays data by year in columns. It is filtered to display the four most recent years of data. There is a column that calculates the 6 year average off of the most recent 6 years of data which I need to update to get rid of 2009 and add 2015. So I want the formula to be the data from years 2010 through 2015. I'm sure the solution is simple, but I can't figure out how to change the formula for all of the cells in the column besides doing it manually. When I change the first cell of the column manually, it doesn't change the rest of the column. So right now the formula displays =('2012'+'2013'+'2014'+'2009'+'2010'+'2011')/6 and I need to change all of them to =('2012'+'2013'+'2014'+'2015'+'2010'+'2011')/6. Any help would be appreciated.
Thank you.