StillUnderstanding
Board Regular
- Joined
- Jan 30, 2021
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello,
I wonder if anyone can help me please? I am using the following code in a cell to return the maximum value in a pivot table =INDEX(A6:A15,MATCH(MAX(B6:B15),B6:B15,0))
The issue that I have is that when the pivot table changes size its only returning the value within the code.
I think you can do this with getpivotdata but I am not sure how?
Can anyone help please?
The table is called PivotTable1
I wonder if anyone can help me please? I am using the following code in a cell to return the maximum value in a pivot table =INDEX(A6:A15,MATCH(MAX(B6:B15),B6:B15,0))
The issue that I have is that when the pivot table changes size its only returning the value within the code.
I think you can do this with getpivotdata but I am not sure how?
Can anyone help please?
The table is called PivotTable1