Function Row()

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 determinedExamples:

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

You can also use this function to determine the row in which the function itself lies. For example, If this function is written in cell $F$5, then the function should return this cell's row number. For this the function can be simply written without the 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.

RELATED POSTS

0
comments:

Post a Comment

Thursday, July 23, 2009

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 determinedExamples:

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

You can also use this function to determine the row in which the function itself lies. For example, If this function is written in cell $F$5, then the function should return this cell's row number. For this the function can be simply written without the 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.