Hello,
I am facing a problem when defining a name, because of the sheet's name:
In my case the sheet name is “Mysheet-T” and the function below does not work.
If I change the sheet name to just “Mysheet”, everything is fine.
=OFFSET('Mysheet-T'!$E$2,0,0,COUNTA('Mysheet-T'!$E$2:$E$65536),1)
Any suggestions?
Bookmarks