Hi,
I am still new with offset and I am not sure what I am missing.
Ok, my formula is =OFFSET(A1,0,0,4,1) which basically means from A1, 0 rows, 0 columns and the height is 4 (A1:A4) and 1 width. How come I am getting different result even if I am using the same formula on 4 different cells?
I was expecting a result of 1 (value in A1) for all cells but it is showing otherwise.
I am still new with offset and I am not sure what I am missing.
Ok, my formula is =OFFSET(A1,0,0,4,1) which basically means from A1, 0 rows, 0 columns and the height is 4 (A1:A4) and 1 width. How come I am getting different result even if I am using the same formula on 4 different cells?
I was expecting a result of 1 (value in A1) for all cells but it is showing otherwise.
Manifest Report 02.18.xlsb | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 1 | 1 | =OFFSET(A1,0,0,4,1) | ||
2 | 2 | 2 | =OFFSET(A1,0,0,4,1) | ||
3 | 3 | 3 | =OFFSET(A1,0,0,4,1) | ||
4 | 4 | 4 | =OFFSET(A1,0,0,4,1) | ||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | B1 | =OFFSET(A1,0,0,4,1) |
B2 | B2 | =OFFSET(A1,0,0,4,1) |
B3 | B3 | =OFFSET(A1,0,0,4,1) |
B4 | B4 | =OFFSET(A1,0,0,4,1) |