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

ROW(S)/COLUMN(S) functions are an efficient way to write formulas that require copying down columns, across rows, or both. However, many users get caught out by these functions because you don’t edit the cell references in the same way you might with other formulas.

0:00 Excel ROW and COLUMN Functions
0:27 ROWS Function
1:37 COLUMNS Function
2:22 ROW Function
4:45 COLUMN Function
6:38 Writing Efficient VLOOKUP with COLUMN(S)
10:36 Using ROW and ROWS to return multiple results
12:43 Mistakes People Make with ROW(S)/COLUMN(S)
13:35 Updating References in Example 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.

[vijayarjunwadkar]

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

[ivanbork]

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

[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)

[chrism]

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

[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

[mohammedadnan]

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

[darrylmorgan]

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

[Everyonelovesyou]

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

[rPppr]

Excel-lent video, great explanations.

[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) 🤗

[robertross]

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.

[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

[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?