What is line 1

Row column()

The description of the ROW function in the Excel help is not complete. An essential characteristic of this function is concealed there:

Line (A: A) or, more generally, line (letter: letter), as a matrix in a perpendicularoriented If the checkbox is entered, the values ​​1 up to a maximum of 65536 are continuously returned.

If only part of a column is marked, these marked cells are numbered consecutively.

The same applies to the COLUMN function (reference).

COLUMN (1: 1) or general column (number: number) as a matrix in a level oriented If you enter the checkbox, the values ​​1 to a maximum of 256 are continuously returned.

Partial markings are also possible here.

Figure 141, Numbering rows consecutively using the matrix function {= row (A: A)}

Figure 142, Numbering columns consecutively using the Column (1: 1) matrix function

If you use the functions row () or column () without arguments (but with argument brackets), row () or column () refer to the current Cell and return the row or column number of the current cell.

The row / column functions are extremely valuable for use in matrix formulas, they are always used when consecutive cells (column (1: 1) for horizontal, row (A: A) for vertical) are addressed in a matrix should.


Didn't find what you're looking for? Enter your search term here!