Forum Discussion
jabrito_56
May 08, 2019Copper Contributor
Reference in the OFFSET function
Hello, I am just learning how to use pivot tables. In an example I have found the formula: "=OFFSET(Summary[@[S. No.]],$O$2,0)", and Excell does not recognize it and I can't find "Summary" beetwen...
SergeiBaklan
May 08, 2019Diamond Contributor
jabrito_56 , that is structured reference. Summary is the name of the Excel Table, and S.No. is column name.