Google Apps Script - Get the Last Row FOR A SINGLE COLUMN

[HSHWKWNXB]

What script when i want to find last data in single column where that column containt formula to make data start in row 2 until last row

[mxrvxn]

Thank you for this vid. what if I have a blank cell/s? for example the c2 is blank and my last cell is on c5? using this function it will return the value of 4.0

[MrValVet]

I was looking for this, but the problem is what to do with cells that are empty?

[sfsiconownersassociation]

Tons of thanks. Have been looking for an easy solution for days. Earlier used the for loop.

[ongNguyen-ndpr]

how can I append data to the last row for a single column?

[kevpad]

Can you show us how to get the last column for a single row?

[trungkienle]

Now I can not use it script because filter is not a function

[findthetruth]

You are always making amazing videos ✌️👌😁. But, I am currently struggling with another issue in Google sheet online in which I am trying to create/ apply protection range only to those raws that have a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it, and I have a column to approve them if I choose "yes approved" then automatically lock these raws for them not let others users be able to edit them, except me, and if it was not then leaving it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.

[monireachtang]

it helps a lot. Thank you so much brother!

[super]

This is way more fast then using for loop.