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!!

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!!

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