I have a named range AL_Year1_Nts.
If I type into a cell, =Max(AL_Year1_Nts) the formula works fine.
If I type Max(Indirect("AL_Year1_Nts")) I get #REF
If I type ="AL_Year1_Nts" into cell B1, and then in C1 type =Max(indirect(B1)) I also get #REF
I've also tried saving the cell as an array formula, but still throws the error. What am I not seeing here?
Thanks for any help. Mark
Bookmarks