**Row()**

This function is used to determine the row number of a given reference (the cell referred to in the function).

**:**

__Syntax__= Row (Reference_cell)

*Reference_cell: This is the cell for which the row number is to be determined*

**:**

__Examples__The function simply returns the row number for the cell which is passed on as reference with the function. For example:

- Row($A$3) - result will be: 3
- Row($C$35) - result will be: 35
- Row($AA$45) - result will be: 45
- Row($BB$125) - result will be: 125

*Reference_cell*. It will be:

**=Row()**

...and the function will return the row number of the cell in which it is contained.

**:**

__Application__Though this function is very simple to use, but is a very useful functions. This functions is mostly applied with other advanced lookup functions, such as vlookup(), hlookup(), address(), etc. This functions works similar to Column() function.

## 0 comments:

## Post a Comment