May 08 2019 09:39 AM
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?
May 08 2019 10:18 AM
@jabrito_56 , that is structured reference. Summary is the name of the Excel Table, and S.No. is column name.
May 09 2019 02:54 PM - edited May 09 2019 02:56 PM
Thank you, I got it!.