You are without a doubt the BEST excel KZfaqr. So clear and easy to understand.

Hi Mynda: have seen many offset function video by excel experts. But yours is the best of the best video on offset function. After watching I can get what offset functions do. Thanks a lot for the simplicity.

Thank you Mynda for the great offset video. I had fun following along with a good cup of coffee this morning :) When ever I see the offset function being used with named ranges in a charts, I always wonder why one would use the offset method vs using a table. I always go for the table method.

Your content is spectacular and very well-produced, thank you for creating this!

Ahhhhh thank you! I needed to sum the last 7 rows of a table and for some reason was struggling with OFFSET. It only took until 2:32 of this video before I got it sorted. Amazing as always Mynda!

Thanks for sharing knowledge, Mynda. Highly informative, as usual 😉

Thank you. Appreciated your lesson with theoretical introduction. best and thanks

Thanks Mynda, I don’t use OFFSET often, so this was a great refresher

Good video Mynda, I often use offset , but not necessarily the way you showed...learning evry day so thanks a lot for your excellent tutorials.

Wow …superbly simple and easy ❤

Thank you again! I've got it from your training!

Thank you Mynda!

Good explanation. Thank you.

Thanks a lot. Very helpful.

Using offsets for chart blew my mind . Great explanation as well as application of a concept/Formula

Thank you for sharing.

I may be a little late for the party, Mynda, but, as always, the information is superb and the explanation is clear and easily understood. Thanks so much for the video AND the file with which we can practice. Thanks!!!

Got the clear understanding for Offset through this video. Simple

Wow!! Always surprise me, thanks!!

A very complete tutorial! Thank you Mynda!

This seems like a great channel that I accidentally found. There is something incredibly hot about a woman who knows how to use Excel this well. To me it's the most underrated program from Microsoft Office and glad to see someone is teaching the deeper functions of an infinitely flexible program.

Great .. thanks.

Thank you

Quality content, as always, Mynda! Thank you!

excellent 👏❤️

I like the way you break down the OFFSET Function in this video. I had tried to grasp it in the past. I could not follow what was happening under the hood. The initial explanation where you demonstrate the behavior of the function using cell references and ranges makes it easier to understand the applications of it. From today i am the OFFSET MVP just because of your Video. Really appreciate. Keep these awesome videos coming.

the best from thailand

Fabulous, as always. Thank you so much for explaing the details in such an aproachable way. PS. I believe there is a tiny glitch in the workbook attached to the newsletter. The formula in DataValidation for the "Select the program" field value should be =$B$67:$B$73 as it's a bit dead now.

Thank you for this helpful video My questions for offset formula: 1- Can we use the offset formula in the tables? 2- Can we use the two nested offset formulas? For example, when using VBA, we can select and select as many lines and columns as we wish in a specific range. In an Offset Range, can a second ranking be selected? 3- In a range, we usually use " " to hide the error values ​​when the Iferror function is used. This is returned by Excel to empty or 0. This takes into account the value formula when determining the number of rows in the offset formula. This gives false results. In a column or line series, how can we explain to Excel whether the relevant count or text is to understand how many values ​​are? 4- Index (): OFFSET() Can we create a data sequence using thise formula? 5- Can we use offset to extract data from different pages or workbooks?

Thank you for uploading the video the offset function has always been a difficult one for me to overcome in grasping its application

Hi Mynda!Really Helpful Explanation Of The OFFSET Function...Thank You :)

Thank you dear Mynda. This has been most helpful.

That is fabulous informative video thank you so much, kindly I wanna ask is there any function I can use for a dynamic range that include blanks in the cells.

Many thanks, Mynda. I've used OFFSET() many times in the past, but only to return a reference to a single cell. Your lesson has expanded my understanding of it, and I can now see other situations where it can be useful.

I used to use OFFSET quite a bit, but now with dynamic arrays I avoid it completely. And that is a good thing: OFFSET is a volatile function that quickly bogs down massive calculations and dynamic arrays are intrinsically much faster to compute. Great video and explanation, though.

Nice...

its nice to understand in very easy manner.

Wow, nice video. I'm designing a template and I believe people with Excel 2019 and earlier version will use it. I want to spill the values just like the way 365 version does it. How do I do that without an error? Using CSE (Ctrl + Shift + Enter) gets rid of the error sometimes, but it only display just the first value.

I really appreciate the way you do offset. Can you help me to change this list given by formula =OFFSET(Sheet1!$A$2,1,,COUNTA(Sheet1!$A$2:$A$10002)-1,1) to start at Sheet3 g8 position?

Hello .I'm enjoying watching your class. Thank you so much. But i have a issue, I'm using excel 2013 and i have followed all the instructions but I'm getting an error. How can i solve it.

Hi Mynda, thanks for sharing. Another great lesson as always! I do have a question though: for the last example before the common errors, is there a benefit to using offset to do this over just making the data an Excel table to keep the ranges dynamic? I learned to love using tables from some of your other lessons, so I'm just curious how using offset for that would compare.

Hi. I’ve gt a problem with the offset’s value error. I try to use 3 index matches in offset function for: reference, rows, cols. Separately all work correctly just when combined give an error. Also tried used Sum at the beginning of the formula syntax -no joy Any ideas to fix it or substitute? Many thanks

-VE value for going LEFT and +VE for going RIGHT is easily understood, but for a long time, I cant brain "-VE value for going UP" and "+VE for going DOWN" (unlike a Cartesian plane). But I guess it has to be so since all sheets start from upper left corner, going right and down is a entropic certainty.

Is there a workaround to OFFSET with the [height] referencing a cell with RANDBETWEEN and thus causing a spill?

Hi. I use the header as reference an go down one row. This prevents the ref error if the first row is deleted

if use offset and save it to the manager !! when i use match the offset wont read the first row for freakin reason its so annoying bug !!

I am not getting values in 3 rows and 2 columns just getting value error and in some cases just one single value

A common mistake I’ve seen is using Offset with merged cells. Because then your count for rows and/or columns changes.

what is the difference, supposed you will just reference a cell by typing "=" and "the cell your making refernce".?

can you one day make a full course on udemy i will purchase it

I am unable to do the same thing as you have done in excel

Voice is very slow in all your videos

Excel users trying to pass themselves off as Developers kill me .

Hello, do you have Instagram?