Forum Discussion
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 the functions. What does it means?
2 Replies
Thank you, I got it!.
jabrito_56 , that is structured reference. Summary is the name of the Excel Table, and S.No. is column name.
