Here are some problems that our users have asked and received explanations on
I need to lock a table reference in an index, match function.
I do not want to change RC[-8]:RC[-5] or RC[-8]:RC[-8] when I drag the formula down
Solved by X. H. in 23 mins
I'm trying to total the values in a pivot table. Essentially i want another value in the pivot table which displays the sum of the other pivot table columns.