“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to lock a table reference in an index, match function.
E.g. =INDEX(R[241]C[-8]:R[377]C[-5],MATCH(RC[-8],R[241]C[-8]:R[377]C[-8],0)+0,4)
I do not want to change R[241]C[-8]:R[377]C[-5] or R[241]C[-8]:R[377]C[-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.

Solved by V. D. in 18 mins

=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)

Solved by I. F. in 30 mins

Grouping not available in pivot table and cannot have more than one pivot table in one worksheet

Solved by O. E. in 26 mins

I have problems with my pivot table . Require an expert in pivot table

Solved by K. C. in 21 mins