I hope you do enjoy this free blog. I only ask one thing from you in return, click in one of the ads

Friday 16 January 2015

ROW function

Category: Lookup and reference functions

What does this function do?


Returns the row number of a reference.



Syntax:
ROW([reference])
  • reference (opcional): The cell or range of cells for which you want to return the row number. If the reference argument is omitted, it is assumed to be the reference of the cell in which the ROW function appears.


Examples:
=ROW(B2)=2
=ROW(C7)=7
In cell A2, =ROW()=2
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)