View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.links
Elysia Elysia is offline
external usenet poster
 
Posts: 4
Default 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