CONCATENATE within SUMPRODUCT
"Bob Phillips" wrote...
It was introduced to reduce the single cell array that
INDIRECT("A"&(ROW()))
....
Ah, the tribulations of the syntactically deprived!
INDIRECT("RC1",0)
and just the one volatile function call.
HAND
|