Hi all
I need to insert a simple average calculation into lots and lots of columns.
Is there a way of doing this that does not involve either:
1) right clicking every column and selecting "Average" from Calculations.
2) Going through slice and dice, clicking on every item, clicking calculator, then changing the calc from Sum to Average.
Surely there must be a built in way of copying the "Average" formula across, such that it references each new column?
Many thanks in advance
Tom
I need to insert a simple average calculation into lots and lots of columns.
Is there a way of doing this that does not involve either:
1) right clicking every column and selecting "Average" from Calculations.
2) Going through slice and dice, clicking on every item, clicking calculator, then changing the calc from Sum to Average.
Surely there must be a built in way of copying the "Average" formula across, such that it references each new column?
Many thanks in advance
Tom