Under the hood of Excel do you think if I use named ranges, for say MAX calculations, it will be more efficient e.g.
I have a named range myNmdRang that is A1:Z20000 with no data in the remainder of the sheet. Column A contains some numeric values. The named range might get adjusted in length tomorrow to 500k rows or just 100rows.
Taditionally I do this to find the MAX in column 1:
Max("A:A")
Is the following more efficient and/or takes up less storage? (can this be proved)
Max(index(myNmdRang,0,1))