Mac,

Select the cells you want in your named range by holding down the Ctrl key
and selecting them. Then:-

Insert|name|Define

name the selected range and formula such as =min(Myrange) should work.


Mike

"Mac" wrote:

I want the MIN function to work over a non-contiguous range, like R10C2,,
R10C10, R10C18, R10C24; can I use a name reange for this ( MIN(the
four_cells_range_name) )? So far it doesn't seem to work, however....