If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
about Offset function
I got a model from a colleague. He used offset function but only with
3 inputs OFFSET(F171,$D$26,0). This is different from what explained in using offset, i.e. Offset(A1, 1, 2, 1, 1). Could anyone help me on understanding this? thanks!! |
#2
|
|||
|
|||
about Offset function
From XL Help ("OFFSET")"
OFFSET(reference,rows,cols,height,width) ... If height or width is omitted, it is assumed to be the same height or width as reference In article .com, Elysia wrote: I got a model from a colleague. He used offset function but only with 3 inputs OFFSET(F171,$D$26,0). This is different from what explained in using offset, i.e. Offset(A1, 1, 2, 1, 1). Could anyone help me on understanding this? thanks!! |
#3
|
|||
|
|||
about Offset function
On Sep 18, 6:01 pm, JE McGimpsey wrote:
From XL Help ("OFFSET")" OFFSET(reference,rows,cols,height,width) ... If height or width is omitted, it is assumed to be the same height or width as reference In article .com, wrote: I got a model from a colleague. He used offset function but only with 3 inputs OFFSET(F171,$D$26,0). This is different from what explained in using offset, i.e. Offset(A1, 1, 2, 1, 1). Could anyone help me on understanding this? thanks!!- Hide quoted text - - Show quoted text - thanks |
Thread Tools | |
Display Modes | |
|
|