OFFSET Formula in Excel

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: trumpexcel.com...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@lisap5615]

Thank you so much! You did an excellent job explaining how the OFFSET Function works.

[@cadjiton]

Thank you Sumit, you have explained very clearly, so useful

[@rajnajat]

A very informative video explained with simplicity. Thanks for the effort !

[@brit411jc]

This was really helpful! I have a much better understanding of what Excel is referencing when I type in "offset". Thank you!

[@serzikableyeah]

Thank you, very helpful!

[@MrJagadeep]

Thanks for the clear explanation !

[@Secretofages-bu3it]

Thanks, I understood

[@HaythamSAtia]

THANK YOU VERY MUCH MASTER. YOU ARE THE MASTER.

[@lukeoneill3136]

Thank you! Very clear explanation.

[@ManagementStrategist]

Great explanation. Thanks!

[@niranjanwjames910]

Thank you .. that was explained very well.

[@user-ku2ed6yx2t]

Thank you Sir

[@sassyprada344]

Thankyou so much

[@romeshkirpalani848]

But what is the use of offset function in a broader context?

[@tunim4354]

Sensitivity analysis in finance.

[@sheetalkumari1720]

Thank u sir..

[@zakzeko5582]

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

[@his-worddevotionals540]

Awesome

[@jenbenedix7557]

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?

[@kamrulzoha9223]

Jen Benedix
Can you send me your example data
If u want than you can shoot one small video
As example and post my Facebook page
[e-mail]
I shall try to solve your problem
Thank you

[@pranavgoyal2366]

but what exactly is offset, you should have explained it first

[@skdaveskdave9798]

it should be iin hindi