How to use OFFSET function for Dynamic Range in Excel
This video tutorial shows "How to use OFFSET function to get dynamic range in Excel" with the help of examples.
The Microsoft Excel OFFSET function returns a reference or specific range of cells that is offset from a given reference by a specified number of rows and columns supplied in the arguments. It can also be used to create the dynamic range for tables, pivot tables, charts etc. OFFSET function usually is used with other functions as customize functions, expecting a reference argument in excel. It is a “volatile” function, and it gets recalculated whenever there is any change to a worksheet.
We have created this tutorial using following features and :
1. How to move rows (up or down) from starting point / reference?
2. How to move columns (left or right) from starting point / reference?
3. How to use Height / Width to get the dynamic range?
4. SUM with OFFSET
5. Learn more about #REF! error
Visit us for daily dose of Excel Tips & Tricks at http://www.exceltip.com/
In case of any simple or complicated "Excel" query, you can ask to our experts for instant solution at http://www.excelforum.com/