Use Excel ROW Function to get the number of rows in an array or reference. In simple words, it will return the number of rows included in a reference.
For example, If you refer to a range A1:B4, it will return 4 in the result.
- array A cell reference or an array to check a number of rows.
More Information on Excel ROWS Function
- You can also use named range in rows function.
- Rows function is not concerned with the values in the cells, it will simply return the number of rows in a reference.
In the below example, I have used reference A1:A10 which has 10 rows in it and ROWS function has returned 10 in the result.
You can also use rows function to create a list of serial numbers. In the below example, I have used the starting cell of the reference as an absolute reference.
So, when I drag the formula down it will create a list of serial numbers.
To learn more about Excel ROWS Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.