Max function for row with named cells
 

I would like to ge the max number from two cells in a given row. Max(A5,A6)
works fine. But if the cells have defined names,(create name, top row) and
i use Max(XMeasA,XmeasB) for example, I get the maximum for both columns
rather than just for the row. Is there some other function available or do I
have to use cell addresses (a pain in this case). Thanks in advance for any
help.

Max function for row with named cells
 

Yes, I came across this a few years ago and found it annoying. If you
use the name of a range, then the whole range will be taken as one of
the parameters, so to avoid that you have to use cell references.

Hope this helps.

Pete

On Aug 27, 11:05*pm, gg wrote:
I would like to ge the max number from two cells in a given row. *Max(A5,A6)
works fine. *But if the cells have defined names,(create name, top row) *and
i use Max(XMeasA,XmeasB) for example, I get the maximum for both columns
rather than just for the row. *Is there some other function available or do I
have to use cell addresses (a pain in this case). *Thanks in advance for any
help.

Max function for row with named cells
 

"gg" wrote in message ...
I would like to ge the max number from two cells in a given row. Max(A5,A6)
works fine. But if the cells have defined names,(create name, top row) and
i use Max(XMeasA,XmeasB) for example, I get the maximum for both columns
rather than just for the row. Is there some other function available or do I
have to use cell addresses (a pain in this case). Thanks in advance for any
help.

GG, you could try if this is practical:
Suppose you want the max of the 2. row
=MAX(XMeasA 2:2,XMeasB 2:2)
There is a space between the ranges, which is an intersection operator.
Pull the formula down.
Hans T.

Max function for row with named cells
 

"Hans Terkelsen" wrote:


"gg" wrote in message ...
I would like to ge the max number from two cells in a given row. Max(A5,A6)
works fine. But if the cells have defined names,(create name, top row) and
i use Max(XMeasA,XmeasB) for example, I get the maximum for both columns
rather than just for the row. Is there some other function available or do I
have to use cell addresses (a pain in this case). Thanks in advance for any
help.

GG, you could try if this is practical:
Suppose you want the max of the 2. row
=MAX(XMeasA 2:2,XMeasB 2:2)
There is a space between the ranges, which is an intersection operator.
Pull the formula down.
Hans T.

Thanks much-works beautifully. GG