As you can tell from the topic itself, this is about RANK Function only.

Ranking is an aspect which is very important for a person who is dealing with loads of data entries. We keep on inputting data, and move according to the product number but in the end of the day, our boss yells at us and says, “This is what your findings are? Which product got the highest sales? Which product is still sitting on the base line? If you cannot bring that out from your data, what are you even doing here? Immature!”.

Previously: Generate Percentage Breakdown of Data summary in Excel 

Oh boy, I did paint the real picture, huh!

So, to rank something in excel, we use the RANK Function. The RANK Function is basically as follows:

=RANK(

To add ranking in your data, here’s an example to understand the same.

Example:

RANK Formula

As you can observe in the image above, we have taken data related to a bunch of roll nos. and the marks they have got in some subject (out of 100).

RANK Formula

The first think to do is input the RANK Function:

=RANK(

The following formula requires number, reference and order.

RANK Formula

In number, we will select the number we want to rank, so in the above case it is cell C3, i.e. marks of Roll No. 3201.

RANK Formula

Then we will come to the aspect of reference, the reference will be our marks range i.e. C3:C10, this is because we are ranking the Roll Nos. on the basis of marks, so our reference will be the marks range.

RANK Formula

In the case of order, we get two options:

(…)0 – Descending

(…)1 – Ascending

As we are talking about marks here, so we will go with option (…)0 – Descending, because the roll no. with the highest marks should be ranked as 1st and not the roll no. who has got the least marks.

RANK Formula

By this, our RANK Function completes, so after closing the same it becomes as follows:

=RANK(C3,C3:C10,0)

RANK Formula

Now all we have to do is press enter and we will get the rank of the following roll no…

As you can observe in the image above, the Roll no. 3201 has been ranked as 7th.

RANK Formula

Now, we will simply drag down the RANK Function so that we get to save time from inputting the formula again and again for every roll no… And there you go, as you can observe in the image above, the roll nos. have been ranked as per the descending order.

RANK Formula

It’s easy, isn’t it?