Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
OFFSET Function 1
- Thread starter Cartwheel
- Start date
-
1
- #2
Hi!
OFFSET(ref,rows,col,height,width)
ref prepresent the reference from which you would like to base your offset.
Rows is the number of rows, up or down fro mthe ref cell, that you want the upper-left cell of the result to refer to. Using 4 for rows argument means that the the upper-left cell of the resulting range is 4 rows below the reference cell(s). The number can be positive [below reference cell(s)] or negative [above the reference cell(s)].
Cols is the number of columns, left or right, that you want the upper-left cell of the result to refer to. Again, using 4 for cols argument means that the upper-left cell of the resulting range 4 columns to the right of reference cell(s). Cols can be positive (right of the starting reference) or negative (left of the starting reference).
Height is expressed in number of rows, that you want the returned reference to be. Height has to be a positive number.
Width is number of columns, that you want the returned reference to be. Width has to be a positive number.
If either height or width is omitted, then the default is the same height or width as reference.
HTH
Indu I will stop procrastinating tomorrow
OFFSET(ref,rows,col,height,width)
ref prepresent the reference from which you would like to base your offset.
Rows is the number of rows, up or down fro mthe ref cell, that you want the upper-left cell of the result to refer to. Using 4 for rows argument means that the the upper-left cell of the resulting range is 4 rows below the reference cell(s). The number can be positive [below reference cell(s)] or negative [above the reference cell(s)].
Cols is the number of columns, left or right, that you want the upper-left cell of the result to refer to. Again, using 4 for cols argument means that the upper-left cell of the resulting range 4 columns to the right of reference cell(s). Cols can be positive (right of the starting reference) or negative (left of the starting reference).
Height is expressed in number of rows, that you want the returned reference to be. Height has to be a positive number.
Width is number of columns, that you want the returned reference to be. Width has to be a positive number.
If either height or width is omitted, then the default is the same height or width as reference.
HTH
Indu I will stop procrastinating tomorrow
- Thread starter
- #3
Thanks so much xlhelp!
If:
"Height is expressed in number of rows, that you want the returned reference to be. Height has to be a positive number.
Width is number of columns, that you want the returned reference to be. Width has to be a positive number.
If either height or width is omitted, then the default is the same height or width as reference."
Then:
what is the returned reference? If the input reference is dy or dx? Do you have a practical example?
If:
"Height is expressed in number of rows, that you want the returned reference to be. Height has to be a positive number.
Width is number of columns, that you want the returned reference to be. Width has to be a positive number.
If either height or width is omitted, then the default is the same height or width as reference."
Then:
what is the returned reference? If the input reference is dy or dx? Do you have a practical example?
Offset(A1,3,5,3,3) will refer to the range F4:H6.
three row down from a1 would be a4. filve columns from a4 would be f4. Then selecting 3 rows and 3 columns would give F4:H6
Similarly
Offset(D7,3,-2) will refer to cell B4
HTH
Indu I will stop procrastinating tomorrow
three row down from a1 would be a4. filve columns from a4 would be f4. Then selecting 3 rows and 3 columns would give F4:H6
Similarly
Offset(D7,3,-2) will refer to cell B4
HTH
Indu I will stop procrastinating tomorrow
- Status
Similar threads
- Locked
- Question