Google Sheets - Get Last Non-Empty Cell in Row or Column

Learn how to get the last non-empty cell in row or column. In this tutorial we'll first create a formula to get the row number for last non-empty cell and then get the data value in the the cell.

#googlesheets #lastrow #lastcolumn

[rbcrist]

Hello. I was watching your videos for the last 3 days and i can tell you the way you explain is perfect. I am SAP consultant with ABAP development skills but i wanted to do something for me with google sheets and java script in which i never worked before ( only excel formulas ). Based on your videos i was able to write my own little program to track some consumptions in the house, etc...by passing values to google sheets and getting values from google sheets in java script. Great teacher !

[sharkattack]

Youtube is amazing. I just picked my car apart and put it back together. Now Im learning excel whoop whoop!

[mrsamot]

Was poking around on the internet looking for a solution to this. Most of them were convoluted for no reason. This was straight to the point! Thanks for the great tutorial!

[malikastar]

As always, you make it easy with no boring explanations, thank you, I'm glad I've found your channel !

[minhthai]

OMG, your channel basically covers all the functions needed for all situation !!

[infact]

Great way of explaining! You are a born teacher! Thanks form the bottom
of my heart!

[walterpaiva]

Your way of teaching is really cool and intuitive. As always, really good video!

[cric]

Nice idea. It works too for a range : Very cool when used with indirect function

[mateushorta]

Thank you so much! I've been struggling so hard to do this for a long time.
What a sophisticated solution to multiply by 0 if the column is empty.

[NSE_Foden]

That is extremely useful. I have combined it with the indirect function to use with dynamic dropdown lists which is something I have been trying to do for a few weeks using information from another of your videos, but couldn’t get it to work.

[peterlaszlo]

Thank you for taking you time to make a video about this. This is really helpful. God bless!

[SaintHanappi]

thanks god I found this helpfull tip about COUNTA, which I use now in an empty cell on top to get the number of rows in my App-script.
I had a big problem with an ArrayFormula within the Data-range and had a ton of non-blank rows in my search-result.

[michaelkahmann]

Your videos are amazing. I have learned a lot. Thank you !

[DanielSAraujo]

that was some genius move, really. thanks for that!!

[manuelfpardo]

This one has a problems if the formula is in the actual row analysed. This one solves the problem.

[cheewurz]

Dude... You are one Smart Guy! How would you make Flash Cards that Auto Expand in Google Sheets?

[enlightenedterrestrial]

Everything works right up until 12:08 with the new INDEX function. The cell simply remains empty!

[ruwanchamara]

superb video....i am learning from your videos.... very help for archive my automation tasks....from Sri Lanka

[dmitryn]

That's elegant! Thank you for sharing!

[diegomouratorres]

That's fantastic! Very useful technique.