| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name of named formula used in an INDIRECT function | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Defined Named cells lined to a Function Procedure | Excel Worksheet Functions | |||
| dynamic named range function | Excel Worksheet Functions | |||
| how do you use named cells in the countif function | Excel Worksheet Functions | |||
Threaded Mode
