I have a pivot table which includes a Grand Total column (currently in column AU). I want to create a named range (Grand_Total_Column) for the column that contains the Grand Total that will move with the column as the pivot table expands.
Grand Total is in row 3.
I have tried using this formula in the Refers To box
=(INDIRECT(SUBSTITUTE(ADDRESS(1,MATCH("Grand Total",$3:$3,0),4),1,"")))
but this did not work.
Any suggestions?
Bookmarks