tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,913
- Office Version
- 365
- 2019
- Platform
- Windows
If I have the values 1,2,3,4,5 in column A, values a,b,c,d,e in column B, values e,f,g,h,i in column C, then if I type (in any cell on the worksheet) the formula:
I get the value of b because it starts at cell A1, moves 1 row down, then 1 column right to cell B2.
What is the significance of the 3rd and 4th args in the formula?
For example, what would this return?
Thanks
Code:
= Offset(A1, 1, 1)
I get the value of b because it starts at cell A1, moves 1 row down, then 1 column right to cell B2.
What is the significance of the 3rd and 4th args in the formula?
For example, what would this return?
Code:
= Offset(A1,1,1,2,2)
Thanks
Last edited: