Best tutorial out there, really friendly and educative, thank you so much I was giving up after several videos without understanding :)
@SimonSezIT3 жыл бұрын
Thank you! Glad you enjoyed the video !
@bluesmaster10052 жыл бұрын
This FINALLY explains "how" the function works, I've been trying to understand the offset for Dynamic Ranges, and this really made it click on the basics of the offset function Thanks!
@SimonSezIT2 жыл бұрын
Glad you found it useful. Thanks for watching :-)
@chinedumjoseph98752 жыл бұрын
This is the best explanation of Offset I have seen. Thank you so much for this.
@SimonSezIT2 жыл бұрын
Glad you enjoyed it!
@bobgreenfield91582 ай бұрын
But show a real example on how this is valuable.@@SimonSezIT
@bobgreenfield91582 ай бұрын
I am still trying to figure out what this function's value is. Do you have more examples? @@SimonSezIT
@tomtom89955 ай бұрын
Definately the best explanation yet on this function. Thanks for this video
@SimonSezIT5 ай бұрын
Wow, thanks! Glad it was helpful. 🤩
@karlstenator2 жыл бұрын
Indirect is the best. Such a great, precise and clear tutorial, thanks for sharing. 🌸
@SimonSezIT2 жыл бұрын
It really is!
@machinegunkely4417 Жыл бұрын
My lady appreciate the tutorial , have a great day a ahead
@cogwheelLearning3 жыл бұрын
I love how you explained everything. Keep it up!
@SimonSezIT3 жыл бұрын
Thank you so much!
@naymyotun65672 жыл бұрын
very well explained video with a lot of examples, Thanks a lot
@bibekkoirala52942 жыл бұрын
Hi Simon! I like your video very much but I am unable to get a sequence of data like at 8:45 minutes. Could you help me on solving this problem in my excel.
@regancrocker92712 жыл бұрын
Easy to understand video on the utility of OFFSET thank you. Just want to be sure last two examples looked to have spilled with the highlighted box around the lookup values. Is this fine?
@kayodeottnnel78252 жыл бұрын
Tried the offset for the ranges... Showed VALUE error
@yogeshpandey176 ай бұрын
I am able to use it properly but everytine I use OFFSET for multiple values it give VALUE ERROR So it is only working if I want to offset single cell I.e. when height and width both are 1 but as soon as I give more than 1 height or width it gives VALUE ERROR Can anyone help please
@Jessy77251 Жыл бұрын
If the reference number is fixed, what is the point to use the offset function? we can just sum the cells. point is to catch the changeable reference cell.