| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
offset not working
I have the following that does work:
=OFFSET('Revenue Assumptions'!D76,D24,C24) I have the following which does not work: =OFFSET(B24,D24,C24) D and C 24 obviously stay the same. My value for B24 is 'Revenue Assumptions'!D76 Any idea why the offset is not working when using for its reference point the written name of a cell? -- Boris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Question for use of offset and range | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
Threaded Mode
