| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
offset() function #VALUE!
1. Name="Data" B4:B11 = {"data", 1,2,3,4,5,6,7}
2. formula =OFFSET(Data,1,0,3,1) 's value is 2 when at E6 , seems fine 3. But same formula becomes an error #VALUE! when at E5 Why different result happens at E5 and E6 with same formula? I think =OFFSET(Data,1,0,3,1) has nothing to do with its own position. -- 事情不耐做，問題不耐看。 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
| Use of OFFSET function | Excel Worksheet Functions | |||
| Help with OffSet Function! | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| help with offset function | Excel Worksheet Functions | |||
Threaded Mode
