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?
@jabrito_56 , that is structured reference. Summary is the name of the Excel Table, and S.No. is column name.
Thank you, I got it!.