View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Russell Jim Russell is offline
external usenet poster
 
Posts: 7
Default 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.