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!”.
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:
To add ranking in your data, here’s an example to understand the same.
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).
The first think to do is input the RANK Function:
The following formula requires number, reference and order.
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.
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.
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.
By this, our RANK Function completes, so after closing the same it becomes as follows:
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.
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.
It’s easy, isn’t it?