| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mixing absolute & relative reference
In C73 I want the maximum of (N73:BE73)
Because columns N to BE are months, once the month is over, I erase column N. Then the formula MAX(N73:BE73) gives an error then. I am trying a mix of absolute and relative addressing, with =MAX(INDIRECT("R[0]C[+11]";FALSE)&":$BE$73"), but this doesn't work (gives "#VALUE!"). Can somebody help, please ? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mixing absolute & relative reference
No error here ...
What error did you get? -- met vriendelijke groetjes "Gilbert DE CEULAER" schreef in bericht ... In C73 I want the maximum of (N73:BE73) Because columns N to BE are months, once the month is over, I erase column N. Then the formula MAX(N73:BE73) gives an error then. I am trying a mix of absolute and relative addressing, with =MAX(INDIRECT("R[0]C[+11]";FALSE)&":$BE$73"), but this doesn't work (gives "#VALUE!"). Can somebody help, please ? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mixing absolute & relative reference
Just a basic indirect reference then.
=MAX(INDIRECT("N73"):INDIRECT("BE73")) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Gilbert DE CEULAER" wrote: In C73 I want the maximum of (N73:BE73) Because columns N to BE are months, once the month is over, I erase column N. Then the formula MAX(N73:BE73) gives an error then. I am trying a mix of absolute and relative addressing, with =MAX(INDIRECT("R[0]C[+11]";FALSE)&":$BE$73"), but this doesn't work (gives "#VALUE!"). Can somebody help, please ? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mixing absolute & relative reference
=MAX(INDIRECT("N73"):INDIRECT("BE73"))
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Gilbert DE CEULAER" wrote: In C73 I want the maximum of (N73:BE73) Because columns N to BE are months, once the month is over, I erase column N. Then the formula MAX(N73:BE73) gives an error then. I am trying a mix of absolute and relative addressing, with =MAX(INDIRECT("R[0]C[+11]";FALSE)&":$BE$73"), but this doesn't work (gives "#VALUE!"). Can somebody help, please ? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range of cells: Convert relative reference into absolute | Excel Discussion (Misc queries) | |||
| Changing Cells from Relative to Absolute Reference | Excel Discussion (Misc queries) | |||
| CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. | Excel Worksheet Functions | |||
| How do I get relative/absolute reference button (macros) | Excel Discussion (Misc queries) | |||
| Explanation Relative/Absolute Cell Reference | Excel Worksheet Functions | |||
Linear Mode
