PDA

View Full Version : Sleeper: Pivot table



frade
08-23-2005, 03:06 AM
Hello,

I have created a pivot table using VBA (please have a look at my code)

I would like to change this code in order to display the
average of RESULTS (already made) but also the standard deviation for
each column. In the below code, one solution could be to replace
"Function = xlAverage" by "Function = xlStdDev" or maybe by
"Function = xlStdDevp" but pratically it's different.

In my example the number of dil (dilutions) is equal to 12
and the number of days is equal to 10 but the values of these variables can change! the formula "standard deviation" (cell A14 - stdev in sheet "TP_REPEAT") is directly one row below this one: "Average of RESULTS"

How to calculate automatically this function for each column?

Thanks a lot

Regards,

Fran?ois