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!
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?
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.
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
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.
Best tutorial out there, really friendly and educative, thank you so much I was giving up after several videos without understanding :)
Thank you! Glad you enjoyed the video !
This is the best explanation of Offset I have seen. Thank you so much for this.
Glad you enjoyed it!
But show a real example on how this is valuable.@@SimonSezIT
I am still trying to figure out
what this function's value is.
Do you have more examples?
@@SimonSezIT
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!
Glad you found it useful. Thanks for watching :-)
Definately the best explanation yet on this function. Thanks for this video
Wow, thanks! Glad it was helpful. 🤩
Indirect is the best. Such a great, precise and clear tutorial, thanks for sharing. 🌸
It really is!
I love how you explained everything. Keep it up!
Thank you so much!
My lady appreciate the tutorial , have a great day a ahead
very well explained video with a lot of examples, Thanks a lot
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?
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.
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
Tried the offset for the ranges... Showed VALUE error
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.