Pivot Table
Perfect!!! Thanks.
"Luke M" wrote:
take a look at the GETPIVOTDATA function (XL help file)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"CMD" wrote:
Hello. If I am using a pivot table to look at different cuts of data, can i
easily use a result from the pivot table in a formula on another sheet?
For example, lets say i have weight entered for a bunch of people. Lets say
i just want to look at males, so I click the drop down for gender and select
males and now i have the average weight for males. i have a formula on
another sheet that uses weight as part of the formula. is there a way i can
get that number to be automaticallt referenced when doing the calculation?
thanks in advance.
Chris
|