Get the First Row Number in a Range in Excel Office 365!!
Tags: exceltemplates, getfirstrownumberina
Published: 2021-01-12 03:52:02

---
title: Get the First Row Number in a Range in Excel Office 365!!
published: true
date: 2021-01-03 16:07:24 UTC
tags: ExcelTemplates,getfirstrownumberina
canonical_url: https://geekexcel.com/get-the-first-row-number-in-a-range-in-excel-office-365/
---

If you want to get the first-row number from a range in your Excel worksheet, what will you do? Of course, there are some possibilities to do that. We are here to introduce three simple ways to get the **first-row number in a range in Excel Office 365**. Let’s see them one-by-one in this tutorial.

## Jump To:

- [**Get the First-Row Number using Row Function**](#1)
- [**Return the First-Row Number using Row Function within MIN Function**](#2)
- [**Get the First-Row Number using Row Function within INDEX Function**](#3)
- [**End of the Article**](#4)

## Get the First-Row Number using Row Function:

- **[Row Function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** – This function returns the first-row number from the set of array elements.
- Let’s consider an example, we are going to find the first-row number in a range **B2:D6**.
- To do this, you need to use the below formula.

**=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(A2:C5)**  

- After entering the formula in the **cell D2,** you can see the result of **first-row number**  **2** in that cell.
- Refer to the below image.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-1-1.png)<figcaption id="caption-attachment-20538">Example 1</figcaption>

## Return the First-Row Number using Row Function within MIN Function:

- **[Row Function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** – This function returns the first-row number from the set of array elements.
- [**MIN Function**](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/) – It returns the smallest numeric value from the range of input values.
- The Row function actually returns an array, so you can use the MIN function to get the minimum value in the array.
- For instance, we are going to get the first row number of the range **A2:C5** using the following 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/)(A2:C5))**  

- After applying the above formula, you will get the result as shown in the below screenshot.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-2-1.png)<figcaption id="caption-attachment-20539">Example 2</figcaption>

## Get the First-Row Number using Row Function within INDEX Function:

- You can also use the [**INDEX function**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) to get the reference of the first row in a range.
- **[Row Function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** – This function returns the first-row number from the set of array elements.
- To get the first-row number using the Row Function within the INDEX Function, you can use 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/)(A2:C5,1,1))**

- After applying the formula, you will get the first-row number as shown in the below screenshot.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-3-1.png)<figcaption id="caption-attachment-20540">Example 3</figcaption>

## End of the Article:

From the above article, you can easily understand the three simple ways to **get the first-row number in a range in Excel Office 365**. Drop your **feedback** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!