LineRel
Returns the row number of the cell to which the function is attached, in relation to another cell.
Syntax
LineRel(reference)LigneRel(reference)
reference = reference of the cell in relation to which you want to retrieve the line number
Remarks
The referenced cell's row number is 1.
This function is only available for formulas attached to a cell in a grid. It can be used to obtain row numbers within a table. References to cells in a different layer are not allowed, so the reference must not include a layer name.
If the reference is a named range covering multiple cells, the top left cell in the range will serve as the basis for the function.
To retrieve the column number in a table, see ColumnRel.
To retrieve the absolute row number, see Line.
Examples
LineRel(B2) = 1 for cell B2, 2 for cell B3, etc.