EXCEL WITH EASE

ROW

2020-01-07T22:41:00.002+05:30

“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 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

2020-01-07T22:41:00.000+05:30

“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])

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

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.

LAST AND UNIQUE VALUE

2018-03-23T19:00:00.000+05:30

Hey Guys!!!

Here's are some questions related to data and must read this post if all your answers will take to next question :-

Have you ever require to get filter Last and unique values from a data ?
If yes what would you like to do then ?
Do you do it manually ?
But if it is in whole data and regular job then what would you do?

Here's a example in which you can find last and unique value from a data table using simple formulas and take decision based upon it. See how it is being done:-

You can learn the formulas used and described in the picture with there details and limitation by clicking on the following :-