Hi all,
I need help on the last part of the formula:
=OFFSET($A$1,(MATCH("Grand Total",A:A,0)-1),COUNTA("where the cell in
column a contains "Grand total"))
This is for referencing the grand total in a pivot table..
I can't use a static top row, as it may contain blank cells, as fields
are added or removed.
Thank you.
Ju
Bookmarks