I don't understand - why doesn't

=MIN($L2:$M2)

"seem to help (your) problem"?

What happens when you drag that formula down the column?

If you enter that in In article
,
Jim Russell wrote:

I have a formula that includes the expression "min(L2,M2)". I want to be able
to name columns L and M, and have those names used in the expression. The row
number is relative, so the formulas below are "min(l3,M3)", etc. (The formula
should be min($L2,$M2) to keep the column references absolute, but that
change does not seem to help my problem.)
How should I name the columns to be able to apply them, and what should the
formula look like when it is done? (I would guess the name would reference,
e.g. $M$M, but what then? The rows do not have names.)
Thanks!