Excel Tips - Tip 28 (Using RANK Formulae)

Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to Rank a Number from Larger to Smaller or vice versa, then use RANK Command to do the same.

What Does It Do ?

·         This function calculates the position of a value in a list relative to the other values in the list.

·         The ranking can be done on an ascending (low to high) or descending (high to low) basis.

·         If there are duplicate values in the list, they will be assigned the same rank. Subsequent ranks would not follow on sequentially, but would take into account the fact that there were duplicates.

How to use it ?

'=RANK(NumberToRank,ListOfNumbers,RankOrder)

·         Using 0 will rank larger numbers at the top. (This is optional, leaving it out has the same effect).

·         Using 1 will rank small numbers at the top.

For example, please check the images.

Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w&usp

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456