OFFSET formula returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
Live Example here:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thank you so much! You did an excellent job explaining how the OFFSET Function works.
Thank you, very helpful!
but what exactly is offset, you should have explained it first
Awesome
it should be iin hindi
This was really helpful! I have a much better understanding of what Excel is referencing when I type in "offset". Thank you!
A very informative video explained with simplicity. Thanks for the effort !
This is really done quite well. Thank you. Really, this is a terrific picture. One could just pause the video and think about it with the power you've given one. Thanks again, and God bless.
Thank u sir..
Thank you! Very clear explanation.
I used offset with counta function to create automatically extended plot range… but it was according to a cells computed from formule… so it does not work well with me …do you have a solution for this? Thanks at all
But what is the use of offset function in a broader context?
Thanks for the clear explanation !
Thank you .. that was explained very well.
I'm trying to print multiple columns for each row on 1 line for example
john smith week 1
john smith week 2
john smith week 3
john smith totals
currently i have page breaks between the weeks but that gives me about 800 pages for all my rows.
I saw an answer on in the forums that said to use the offset function but I have no idea where to put it or how it would really work?