The ROW and COLUMN functions are used to obtain the row and column numbers of a target cell.
The most common use is to assign sequential numbers that can easily be used to add or delete matrices.
They do not have many uses on their own, but when combined with other functions, they can be highly effective, so they are useful functions to remember their existence.
It is similar in name to the ROWS and COLUMNS functions, but they are different functions.
How it works
=ROW(reference) =COLUMN(reference)
| Name | Omission | Explanation |
|---|---|---|
| reference | A cell with a formula. | Specify the cell from which to obtain the number. |
Demonstrate
If the reference is omitted, the number of the cell with the formula is obtained.
Given a reference, get the number of that cell.
Spill
If you specify the reference as a range of cells, it will be a Spill.
---