Forum Discussion
Creating a pivot table from a table that is independent of table/sheet name and works on any sheet.
I recorded this macro using the "MAcro building" sheet in the attached worksheet (it is also the final result). It creates a pivot table (sourced from a table within the same sheet) that displays the...
David,
Just in case... you don't need a pivot table to calculate Standard Deviation and Average Deviation.
Excel includes functions that return both of these values...
= AveDev(Range) - no sample data option available
= Stdev.S(Range) - based on a set of sample data
Jim Cone
https://goo.gl/IUQUN2
Thanks, James. But this doesn't really help, unfortunately.