Pivot Table
 

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

Pivot Table
 

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

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