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 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
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.
Share on Google Plus

About Nifty Guru

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Thursday, July 23, 2009

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 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
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.

Function Row()SocialTwist Tell-a-Friend

0 comments:

Post a Comment