Excel Rank Function with different ranks for same values

This video will help you get Ranks in Excel, without repetative Ranks

The normal =Rank function in Excel gives you the same rank for 2 or more same values.
For example, if there are 4 values - 34, 30, 38, 34; ranking is done in descending order,
38 will get rank 1
34 will get rank 2
34 will get rank 2
30 will get rank 4

This can be avoided using =Rank with =Countif function.
Thus, 2 same values will get different ranks, one after the other.

So the new ranking will be,
38 will get rank 1
34 will get rank 2
34 will get rank 3
30 will get rank 4

---------------------

After this video, learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel

Also, as you are a special Viewer/ Subscriber,
we would like to give out a special discount just for you,
so click here -
---------------------------------------------

SUBSCRIBE NOW!

Blog

Rushabh Shah is an expert in training Professionals & Students in Excel's Advanced features & formulas. These tutorials are simply a way to spread the knowledge and make people more productive using Excel.

[SyedPitu]

Thanks! I have just resolved an issue related to your May Allah bless you!

[gautamsane]

TILL NOW! lol this is a great explanation - very straightforward

[chi-chiowunwanne]

Thank you very much...I have been looking for this specific situation. In other videos, the total were ordered in a descending order.

[khalidjamal]

This one is very helpful for me ...
Thanks for making this beautiful video😍😍😍😍

[AnindyaDasAdhikary]

What formula should I use to rank students of duplicate scores different on basis of another parameter, which must not be included in score?
For an example, if 2 students got same marks in exam the one with higher attendance will rank higher than the other.

[ESCTom]

thank you for explaining this so well!!!

[IkhlasAzali]

thank you very very very very much sir.... you have solve my problem..

[zachariahkuch]

wonderful !! thank you for this video. you saved me. keep it up

[alphamoron]

thanks..i've been searching for this fourmula

[nickbell]

Wonderful, please continue to do more videos, videos are very useful

[Erwin]

Thank you so much... Great help... More power...

[md.saifulislamtuku]

It's helpfully video my jobs, so brilliant thanks

[kalaiarasi]

Excellent, Excellent 👏👏👏👏Thanks a ton

[terrymadeley]

That was super clear and helpful. Thanks!

[digitaledubd]

total mark GPA
850 5.00
870 4.96
840 5.00
866 4.96 How to rank

[ReR]

The purpose of this video was well explained. However, you have the students ranked alphabetically for "total" then the "the new rank formula" just cedes the "total" I scrolled down on the info tab and couldn't find a previous video explain that pre ranking formula. In sports (football) could be rank based on points>goal diff>goals scored>goals against>alphabetically, etc...

[ociramlap]

would it be unfair for the student with the same scores to rank lower?

[satyaminstaid]

Suppose 2 students get the same marks and get same rank . If both of them got 2 rank then the 3 rank doesn't show by applying this formula its start from 4, how to set rank according like 1 2 2 3 4 5 5 6 7 8

[Innervoice_Sukoon]

Can you please help
Please give the correct formula of RANK like this

A-100--1 rank
B-100--1 rank
C-100--1 rank
D-90--2 rank
E-80--3 rank
F-100--1rank
G-90--2 rank
H-100--1 rank
I-90--2 rank
J-80--3 rank

Here if the student getting same no they got all same rank
And there is no skip of any rank also
If a student got 100 then for every student it is rank 1 not 1, 2, 3, 4....