Excel Formulas to Find Last Row Number in a Range in Excel 365!!
Tags: excel, excelformula, excelformulas
Published: 2021-10-25 13:15:43

---
title: Excel Formulas to Find Last Row Number in a Range in Excel 365!!
published: true
date: 2021-10-23 17:27:18 UTC
tags: Excel,ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-last-row-number-in-a-range-in-excel-365/
---

In this tutorial, we are going to look at how to **find the last row number in a range** in Excel Office 365. We will show you the easy steps for completing the task quickly. 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)

## Generic Formula:

- You can use the below-mentioned formula to find the last row number in a range in Excel.

**=[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/)(rng))+[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(rng)-1**

## Formula Syntax Explanation:

- **[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)**– This function will return the smallest numeric value from the range of input values.
- **[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** – It helps to return the row number for reference.
- **[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)** – This function returns the count of rows in a given reference.
- **rng** – It represents the input ranges.
- **Plus operator (+)** – This symbol is used to add the values.
- **Parenthesis ()** – The purpose of this symbol is to group the elements.

## Practical Example:

To find the last row number in a range, refer to the below given example.

- In the following image, you can see the **input data in three columns** as **Columns B** , **C** , and **D**.
- Now, select any cell where you want to print the result.
- We have selected **cell F5** to get the output.
- **Enter the above-mentioned formula** in the selected cell.
- After hitting the Enter button, you will **get the result as shown below**.

## Bottom-Line:

In this tutorial, we guided you to know how to **find the last row number in a range** in **Excel Office 365** with proper examples and screenshots. Kindly, give your **feedback** in the below comment section.

Thanks for visiting **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- [**Excel Formulas to Count Variable Range with COUNTIFS Function!!**](https://geekexcel.com/excel-formulas-to-count-variable-range-with-countifs-function/)
- **[Excel Formulas to Define Range Based on Cell Value ~ Quickly!!](https://geekexcel.com/excel-formulas-to-define-range-based-on-cell-value/)**
- **[How to Add Row Numbers and Skip Blanks? ~ Simple Guide!!](https://geekexcel.com/excel-formulas-to-add-row-numbers-and-skip-blanks-simple-guide/)**
- **[Excel Formulas to Generate Random Value from List or Table ~ Quickly!!](https://geekexcel.com/excel-formulas-to-generate-random-value-from-list-or-table/)**