Google Sheets Dynamic Apps Scripts using Named Ranges

[@DanKulibert]

Brilliant. I've usually looked at the header row and found the indexOf, but that required the name not to change to find the column index.That got me in trouble a couple time :)

[@the0son0of0ben]

This is life changing! Wish you could have mentioned this in one of your old videos when I was learning 😂.

[@66Komodo]

Thank You. Your videos are very informative and not complicated, easy to understand. So i learned a lot.

[@getitdonetube]

Great to hear!

[@SaintHanappi]

Outstanding as usual 😇💥💯

[@getitdonetube]

Thank you :)

[@battlebear]

Always love your video. Thank you so much.

[@getitdonetube]

Thanks for watching!

[@teacherlend9800]

cool video. Thanks

[@ashleysangma407]

This is so helpful, thank you so much!

[@getitdonetube]

:)

[@lionelhue]

So usefull !

[@ygge2007]

It's possible to name only the cell F1 and get the row of column of that cell in the apps script or if there an enum in getnextcell that gets the first non-empty cell from top-down?

[@高吉米-p1b]

When to share new video???

[@felixpalganjr.7410]

Genius!

[@getitdonetube]

:)

[@omenworks]

Hold on Learn Google Spreadsheets... You have a second channel that has been out for almost two years, and I only learn about it now?!? T_T

[@getitdonetube]

Educational content is not doing well on youtube at the moment, so I'm not surprised :)