How to Get the Last Row Number in a Range? ~ Simple Methods!!
Tags: excelbasics, excelpreface, exceltutorials, getlastrownumber
Published: 2021-01-18 04:03:05

---
title: How to Get the Last Row Number in a Range? ~ Simple Methods!!
published: true
date: 2021-01-17 10:51:16 UTC
tags: ExcelBasics,ExcelPreface,ExcelTutorials,Getlastrownumber
canonical_url: https://geekexcel.com/how-to-get-the-last-row-number/
---

Sometimes, you need to know the last [row](https://geekexcel.com/excel-office-365-rows-insert-delete-hide-unhide/) number for the Excel range. In this article, we will learn how to get the **last row number in range using the Excel formulas**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Three ways to get the Last Row:

Let’s see the below steps to get the last row number in range using the Excel formula through the following three ways:

### 1. Using ROW and ROWS function:

- To get the last row number you can use the below formula based on the **[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** and **[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)** function.

**=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(range) + [ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(range)-1**

- First, we will give the input values.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Range-5.png)<figcaption id="caption-attachment-21024">Input Range</figcaption>

- Then, apply the given formula in the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section.

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-1-1.png)<figcaption id="caption-attachment-21025">Enter a formula</figcaption>

- In this formula, the **ROW** function will return the first number in a selected range.
- The **ROWS** function calculates the total number of rows in a range.
- After that, it performs an addition operation then subtract 1 value from the total.
- Finally, we will get the result as the last row number for the range.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-1-1.png)<figcaption id="caption-attachment-21026">Result</figcaption>

### 2. Using the MIN, ROW and ROWS function:

- You can also find the last row number using the [**MIN function**](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/) along with the **ROW** and **ROWS** function. Let’s see the formula:

**=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)([ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(range)) + [ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(range)-1**

- Apply the given formula and press Enter key.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-2-1.png)<figcaption id="caption-attachment-21027">Enter the formula</figcaption>

- The [**MIN function**](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/) will help to return the smallest numeric value from the range of input values.
- After entering the formula, you can get the last row number as shown below.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-2-1.png)<figcaption id="caption-attachment-21028">Result</figcaption>

### Using ROW, INDEX, and ROWS function:

- To get the last row number of input values in your worksheet, you can also use an **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**.
- Refer to the below formula.

**=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(range,1,1)) + [ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(range)-1**

- You just enter the above given formula based on your input data.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-3-1.png)<figcaption id="caption-attachment-21029">Enter the formula</figcaption>

- Then, press the Enter key to get the output.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-3-1.png)<figcaption id="caption-attachment-21030">Output</figcaption>

## Wrap-Up:

From this bride tutorial, we have learned the different ways to **find the last row number in Excel Office 365** with practical examples. Go for it. If you have any **doubts,** feel free to share it with us. Thank you!! To learn more about Excel, just click here: **[Geek Excel](https://geekexcel.com/)!! **

### Read Ahead:

- [**How to Find the Smallest Number Without Formula in Excel?**](https://geekexcel.com/how-find-smallest-number-without-formula-excel/)
- **[Get the First Row Number in a Range in Excel Office 365!!](https://geekexcel.com/get-the-first-row-number-in-a-range-in-excel-office-365/)**
- **[Excel Formulas to Get the content of Given Row and Column!!](https://geekexcel.com/excel-formulas-get-content-given-row-column/)**