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