ROW

No Comments

“ROW”

Used for – “ROW” function in MS Excel is used to get the absolute position of the row of the reference cell.
Syntax – ROW([reference])

             [reference] – This is an optional field as it is written in square brackets. It is a address of any cell for which we want to know the absolute position. The result of the this function is a numeric. If we do not put any reference it will consider the cell in which this function is typed and give the absolute position of the same.
                       
Example – Following example will clear the ROW function:-

In below table formulas are shown which which reflects the various reference type for the function ROW:-

=ROW(A1)
=ROW(AA1)
=ROW()
=ROW(A11)
=ROW(BA1)

=ROW(A9999)
=ROW(TAA1)

Below table shows the result of the above function if copied to cell A1 to C3 in any worksheet of workbook:

1
1
1
11
1

9999
1


Below is a typical summary of the Column Function in the pictorial form with more advance typical information:
Summarized Row Function
Summarized Column Function
Note:
-Here it should be noted that reference should be used for single cell. If a range is selected then it will give the absolute row position of the top left cell of the range.

COLUMN

No Comments

“COLUMN”

Used for – “COLUMN” function in MS Excel is used to get the absolute position of the column of the reference cell.
Syntax – COLUMN([reference])

             [reference] – This is an optional field as it is written in square brackets. It is a address of any cell for which we want to know the absolute position. The result of the this function is a numeric. If we do not put any reference it will consider the cell in which this function is typed and give the absolute position of the same.
                       
Example – Following example will clear the COLUMN function:-

In below table formulas are shown which which reflects the various reference type for the function COLUMN:-

=COLUMN(A1)
=COLUMN(AA1)
=COLUMN()
=COLUMN(A11)
=COLUMN(BA1)

=COLUMN(A9999)
=COLUMN(TAA1)

Below table shows the result of the above function if copied to cell A1 to C3 in any worksheet of workbook:

1
27
3
1
53

1
13547


Below is a typical summary of the Column Function in the pictorial form with more advance typical information:
Summarized Column Function
Summarized Column Function 

Note:
-Here it should be noted that reference should be used for single cell. If a range is selected then it will give the absolute column position of the top left cell of the range.

Is this article helpful to you?

Amazon