View Single Post
  #4   Report Post  
 
Posts: n/a
Default

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.