Get the Last Row Number Even When the Data Contains Blank Rows

There are times when we need to get the last row number of an Excel data range. This could be to feed another function or to validate that the correct number of rows were imported into your spreadsheet.

In this video, we’ll look at two equations to return the last row number of your data. The first equation works for continuous data. The second works for continuous data and when the data contains blank rows.

Thanks for watching.


🎬 YOUTUBE LINKS 🎬
————————————
Work Faster in Excel with These 10 Essential Keyboard Shortcuts: Work Faster in Excel with These 10 Es...


⏱ TIMESTAMPS ⏱
————————————
0:00 Introduction
0:28 Outline
0:41 Equation 1
3:11 Equation 2
5:46 Wrap up


📸 PIXABAY MEDIA 📸
————————————
Image by OpenClipart-Vectors from Pixabay
Image by Clker-Free-Vector-Images from Pixabay

• #education
• #find_last_row