Hello. I've just tried to use a structured reference (eg sheetname!tablename[columnname]) inside a SERIES formula without luck, the instant I press enter excel replaces the structured reference with an absolute reference (eg sheetname!$a$1:$a$10). Trying to use INDIRECT doesn't help either, as excel shows a "that function is not valid msgbox". I'm trying to find a simpler way to do dynamic named ranges. Does anyone know some trick to make this work?
Thanks for your time!
Thanks for your time!