Find Last Row in Excel & Google Sheets data with a Formula

How to find last row in Excel & Google Sheets data using a formula?

#excel #googlesheets #formula

[hylpemadras]

Thanks. Just what I was looking for. You have a knack for solving seemingly difficult problems very logical. I used your concept to calulcate range corners to be able to trim any range. Here's the final formula that can be dropped into a Named Function in Google Sheets. Just add a range variable to it and it will output the trimmed range:
=LET(offset_rows, MIN(ARRAYFORMULA(IF(range="", "", ROW(range))))-ROW(range), offset_cols, MIN(ARRAYFORMULA(IF(range="", "", COLUMN(range))))-COLUMN(range), height, MAX(ARRAYFORMULA(IF(range="", "", ROW(range))))-ROW(range) - offset_rows + 1, width, MAX(ARRAYFORMULA(IF(range="", "", COLUMN(range))))-COLUMN(range) - offset_cols + 1, OFFSET(range, offset_rows, offset_cols, height, width))

[hoiyinwan]

Amazing, thank you for your teaching! Deeply appreciated!

[vinodkumarPrajapativnd]

always love your work from the beginning...

[chocochiligaming]

Can you make a video about. Creating a serial or batch number using textjoin, count or countif or countifs (with duplicates) and create a series out of that duplicates.
Example
Red batch number - R-001
Red batch number - R-002
Green batch number - G-001
Red batch number - Red-003

Even this is not properly arranged because thats the way it was inputted to the system.


Thanks. Im willing to send an example that ive been working on and im having a hard time getting the formula right. Thanks

Your vid helped me alot at my work.

[markuswinter-cdps]

Is there a way to extract the cell reference/address to then use in a different formula? In your original example (before you started adding data), it would have been B11. Thanks.

[joyuutube]

How do you pick up the cell value? Thanks in advance

[SayafAmer]

Sir we need more tutorials about Xpath. Can you make another video tutorial just like the previous one (Scrape your channel contents)?

[PeteerY]

Thanks for your video. I have an Excel 2016 and I followed your example with a range of data, but got a #VALUE! error. Any idea what I did wrong? Thanks a lot.

[Puner]

Teacher...that's very Nice!!!
What would you do to the Formula to Return the Last Cells ROW and Column Location?

[InvestInFrench]

If in the part (A:D=""), i want to have multiple argument, like $A$1:$A23=A24 and $B$1:$B23=B24... how can i do that? Thank you

[vinodkumarPrajapativnd]

Can we do this: flash a particular cell. I mean just blink continuously...

[GustavoMartinsShow]

Cool video, but I didn't see how to use this in a pratical situation. (I'm not a hater, big fan from Brazil)

[henkvinck]

Hello can someone help me.
I want to know the last row of 1 collom there the digits containing volume. Now i have been trying for 2 days to make this myself via video, s but i get error messages everywhere.

This is the formula; can anyone find out where the error is here. it is made for google sheets.

=ARRAYFORMULA(MAX(If(E76:E="", "", Row(E76:E))))

Thanks in advance for your help.

[yangmagic]

I used the Hyperlink function in this video and use the last row number, but it didn't work. Any advice?