How to use Excel ROW function

Introduction

ROW function in excel is a reference function. It returns the row number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =ROW(A9) returns 9 as A9 is the 9th row in Excel.

Syntax

=ROW(Reference)

Arguments

Reference- It is the reference made to a cell or a range of cells whose row number has to be found. It is optional, and since function will use default reference of the cell in which it is used.

Keynotes

  • It returns a number for the row in Excel based on reference, if a row number is to be found using lookup, use the MATCH function.
  • Reference here is not compulsory since function will use default reference of the cell in which it is used.
  • In this function, only single reference can be used and multiples are not allowed.
  • If reference to more than one cell is made, it will return the cell number of uppermost left reference.
  • It can also be used to create a list of row numbers.(See in Examples)
  • It can also be used to dynamically increment a calculation value.(See in Examples)

Examples

  1. In this example Row function gives us value ‘1’ since we have used the formula =ROW(A1)
row function

In this example a serial vise list of row numbers is created using ROW function simultaneously.  

In this example a dynamical increment of a calculation is done using the ROW function. It means value of the calculation will automatically increase when function is pasted to a new cell. Here the formula  =A12*(ROW(D12)-11) is used in column D12 , this multiplies value in column A12 by 1 and increment by one as we move to the next column.

2 thoughts on “How to use Excel ROW function”

  1. ANANT KUMAR TIWARI

    Dear Sir

    please send activation code for use your gst software

    1. Excelhub

      pls subscribe to get code

Leave a Comment

Your email address will not be published. Required fields are marked *