Rank Scores in Excel | With or Without Ties | Rank by Group - RANK IF by Criteria

In this video I demonstrate how to rank values in Microsoft Excel. This video will answer the following queries:

How to rank highest to lowest
How to rank lowest to highest
How to perform an average rank
How to rank without ties or duplicates
How to rank without skipping numbers
How to rank by group
How to rank by condition
How to create a RANK IF formula

Table of Contents:

00:00 - Introduction
00:18 - Rank scores using RANK.EQ
01:00 - Rank scores using RANK.AVG
01:42 - Rank giving smallest value a rank of 1
02:28 - Rank with no ties
04:35 - Rank by group - conditional ranking
------------------------

[IvanCortinas_ES]

Excellent tutorial. Thank you Chester.

[Raelsalmacis]

Thanks a lot for the video.
Pretty useful!

What should I do if I want to exclude ties when ranking by group?
Example: in your latest example we have 2 females with the same score.

[gautammalhotra]

How do you remove ties in the last example with countifs?

[ahmedeldorry]

Thank you so much for your very informative vedio 👍👍

[johnfrohlich]

Hello I'm attempting to use the VBA method. It is working on my spreadsheet, however Im attempting to use the rank number as a priority setting that I can change on my list to reorganize the list to my highest priority. Example, list item, take out the trash- rank 5. I change the rank to 1 because it is now the highest priority and everything moves and shifts however, now I have 2 number 1 rankings and I'd like the list to insert the line item and adjust all the ranks below 1 by adding 1 to 1, 2, 3, 4. Thus, resetting the ranking in sequential order. Is this possible?

[bunty]

In last formula how to get unique rank?plz suggest

[CRASIACABB]

thank you so much. i'll follow you.

[shyam]

Very good tutorial. Thanks.
I have more than 200 students in a class of various faculties in the same sheet. Also a few students secured same marks in the same or different faculty. I want to rank them faculty wise. I use MS Office 7 where these options are not available as shown in the Video. Will you please make a video on this problem?