What are these ROW/COLUMN functions doing in my Excel formulas?

[@circadiandream]

I have been struggling for years with Lookup use cases like the "Helmets" one you demonstrated. This makes so much sense now! It is simple and elegant and makes me love Excel even more!! Thank you @MyOnlineTrainingHub your tutorials are a gift.

[@MyOnlineTrainingHub]

Glad it was helpful, Cody!

[@vijayarjunwadkar]

Very useful as usual! Thank you Mynda for doing a great service to Excel users on a variety of topics! 😊

[@MyOnlineTrainingHub]

Glad you think so, Vijay!

[@ivanbork4175]

Dear Mynda
As always, very well explained, especially the part about Sequence is new to me, thanks

[@MyOnlineTrainingHub]

Great to hear, Ivan!

[@chrism9037]

Very helpful, thanks Mynda. I need to start using these more in my formulas.

[@MyOnlineTrainingHub]

Great to hear, Chris!

[@JoseAntonioMorato]

Dear Mynda,
In the «COLUMN(S) Examples» worksheet, the use of the FREQUENCE function was missing:
=VLOOKUP(A25,Table1,SEQUENCE(,4,2),0)
There is also the following possibility:
=VLOOKUP(A26;Table1;{2,3,4,5};0) 🤗

[@MyOnlineTrainingHub]

Nice. Thanks for sharing, Jose!

[@Excelambda]

Great video!! Very eloquent presentation. ✌
for last value, off topic alternatives:
=LOOKUP(2,1/(D3:D14""),D3:D14)
=XLOOKUP(TRUE,D3:D14"",D3:D14,,,-1)

[@MyOnlineTrainingHub]

Thanks for sharing!

[@mohammedadnan8641]

as usual !!! awesome video !!! lot of thanks for your participation in teaching excel .

[@MyOnlineTrainingHub]

Glad you liked it 😊

[@darrylmorgan]

Hi Mynda!Great Tutorial,Super Helpful Explanations...Thank You :)

[@MyOnlineTrainingHub]

Glad it was helpful, Darryl!

[@Everyonelovesyou]

Thanks for sharing great contents, making it easy solve problems in an easy and quick way.

[@MyOnlineTrainingHub]

Glad you liked it!

[@robertross9269]

Need some help with pulling data and then using macros. The files daily have the date in the file name. Each time I run my macro I need to debug and change the date in the macro to the current date for my macro to work. Is there a better way to do this? Thanks so much, love your videos.

[@MyOnlineTrainingHub]

Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@Channel-Ignacio]

Hi Minda I do not know how to write you by DM, just would like to know if you plan a tutorial about Gant Diagram in Excel. Thanks in advance for your answer

[@MyOnlineTrainingHub]

I have several:
www.myonlinetraininghub.com/excel-gantt-chart
www.myonlinetraininghub.com/excel-conditional-formatting-gantt-chart
Including a dashboard: www.myonlinetraininghub.com/excel-project-management-dashboard

[@teoxengineer]

Hello, mynda,
For example, in the formula of row (1: 5), how can we dynamically express the expressions "A:E" in the expression "1: 5" or = column (A:E).
For example, let's ask that we want to extract the data in parentheses from another page and we want to dynamically change the values of Row and Columns according to these values. How can we do this?

[@MyOnlineTrainingHub]

Hi Emre, I'm not sure what you mean. Perhaps you can post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@olipeeeeee]

Thx, very useful. Today I got the feeling that this video shows me a way too solve a big problem I have with a list with a lot of dates and blanks in between. I not sure for now, but after watching this „a got that feeling“ I am probably sure you know what a mean. 😅 thx a lot. Greetings from Germany

[@MyOnlineTrainingHub]

Glad it will be useful! If you get stuck, feel free to post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@0rP3pp3r]

Excel-lent video, great explanations.

[@MyOnlineTrainingHub]

Glad you enjoyed it, Corey!

[@hamidsh4789]

Excellent, Thanks. 🙏🙏🌹🌹

[@MyOnlineTrainingHub]

So nice of you 😊

[@jessicasommer2152]

Just Excel-lent 💚

[@MyOnlineTrainingHub]

😁 Thank you!