What ROW does
ROW returns a row number. It often appears inside larger formulas where you need Excel to count positions dynamically instead of hard-coding them.
Practical examples
Return the row number of a specific cell
=ROW(D10)
This returns 10.
Use ROW inside a dynamic formula
=ROW(A2)-ROW($A$2)+1
This pattern turns worksheet row numbers into a running sequence that starts at 1.
Common mistakes and notes
Omitting the reference changes the behavior
If you use ROW() with no argument, Excel returns the row number of the cell that contains the formula.
Ranges return the first row unless spilled as an array
If you pass a multi-row range in a normal formula, Excel returns the top row number rather than every row number.
ROW is often a helper, not the whole solution
By itself ROW is simple. Its real value usually comes when it is nested inside formulas that need position logic.