Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
offset and Sum function | Excel Worksheet Functions | |||
OFFSET FUNCTION | Excel Discussion (Misc queries) | |||
Offset function help | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Using the Offset Function | Excel Worksheet Functions |