Row Function in M S Excel

Dear friends today I will discuss what is row function in excel, I will discuss in detail about it with 2-3 example, so be with us and read full blog

What is Row Function in Excel

Row function of excel provide unique sequence to each row number excel database or within the result data set.

See the below example, you can see each row has unique sequence number.

How Row function works in excel

Row function is a built in function of excel. It takes only one argument i.e. cell reference and give the row number.

=Row(A5) it will return 5

= Row(A6) it will return 6

=Row(10) it will return 10

Note here row function return the row number not the value of the cell

Example1

Here you can see the parameter/argument passed in the row function and its corresponding result

Let us understand with the help of one more example

Suppose you have to generate a serial number starting from row number 4 i.e. C4. From C4 for C10

the row function =ROW(C4) will give you result 4, but you want 1 at Cell C4. In such case your have to subtract 3 from that value like 

=ROW(C4) - 3, this will return 1 and if you drag down it will create a sequence form C4 to C10

Example2

    =ROW(A1:B10) - What it will return?

It will return 10 ,this means there is 10 rows available in the selected range.

Example3

If we want to count the number of available rows in the range A1:A1000, we can put the formula like =ROW(A1:A200)

In this case it will return 200, that means there is 200 rows available in the selected range or the count of available rows is 200 in the selected range 

 

Let us understand with some more example

Suppose you have list of student with name and roll number. As you know the roll number is both odd and even,

Now the task is to highlight the all the student having even roll number

Example4

This is the list of name of students with roll number at the end, 

Now the task is to highlight the Odd row number with green color

There are various way to achieve this task, I am showing my own way you pleas show your way in comments

Step1. Go to Conditional formatting in home section and then choose New rule

Step2. Once you click on the new rule, a new dialogue box will appear. From that dialogue box choose the last option Use formula to do formatting and put the formula below the box highlighted

Step3. In the below text box put formula =EVEN(ROW())=ROW()

            

Step4. Select the desired color you want and select OK

And you will get the result.

For more such amazing excel technique, please visit our You tube channel  Crazy Excel Tricks

Also visit

For more clarity pleas visit the below link