Copy and paste formula outside pivot table using information from table

Originally Posted by oeldere

use the averagefunction of the pivot table instead.

Otherwise amend the table and make the data there.

After that the data is also available in the pivot table.


There is also a function =getpivottable (see for the right name of it in the help of excel).

Another way of doing it is =c7/b7 and drag down.

Thanks for reply.

The problem with adding to my pivot table through the source data is it would only give me the average per distance , and not for each individual race type per distance. The way I wanted to do it is as you mentioned, c7/b7 and drag it down, but when I do that it just keep the same data from the original formula, it doesn't manipulate the cells within the formula. I do remember something a few years ago where I needed to hold down buttons on the keyboard when entering an initial formula, but I can't remember what that was and whether it would even be the right thing to do for this problem.

Thanks again
Gemma

Just looked again and my problem is I have been doing the formula by clicking on c7 instead just typing it, so thank you it works fine. Obviously just a blonde moment this brunette was having lol.

Thanks for your help,
Gemma