Thread
:
column to row in formula
View Single Post
#
4
[email protected]
Posts: n/a
Bob Phillips wrote...
In A10: =INDIRECT("A"&COLUMN())
....
INDIRECT is unambiguously volatile. INDEX doesn't seem to be. If so,
then
=INDEX($A:$A,COLUMN())
would be more efficient since there would presumably be many such
formulas.
Reply With Quote