Hello,
I'm trying to use an offset(-1,1) to pull the last row of a pivot table before the Grand Total line. I've tried a few different things but I keep getting errors.
Thank you
Hello,
I'm trying to use an offset(-1,1) to pull the last row of a pivot table before the Grand Total line. I've tried a few different things but I keep getting errors.
Thank you
hi there. assuming the numbers you want are in column B and the word "Grand Total" in column A, then:
=INDEX(B:B,MATCH("Grand Total",A:A,0)-1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Ah yes, the old index(match) trick. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks