Apply names to relative references
"Bob Phillips" wrote:
=MIN(INDEX(colL,ROW()),INDEX(colM,ROW()))
....
Thanks. That does indeed work, but it does do some violence to the
readability of the formula. Interesting that "colM" (the range name by
itself) returns the single value for the same row as the formula, but putting
it in a MIN function does not work (e.g. MIN(colM,colL) -- that returns the
min value of all cells in the named ranges.
|