Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 337: RANK function 10 Examples


See how to Rank numbers in Excel:
1.Rank Smallest To Biggest (Ascending)
2.Rank Biggest To Smallest (Descending)
3.Ties Given Same Number e.g. second rank is 2, 2, 2 for three scores of 10, and next rank is 5
4.Ties Given Same Number e.g. second rank is 3, 3, 3 for three scores of 10 ((2+3+4)/3 = 3) , and next rank is 5
5.Ties Given Same Number e.g. second rank is 2, 2, 2 for three scores of 10, and next rank is 3
6.Ties given different numbers e.g. second rank is 2, 3, 4 for three scores of 10, and next rank is 5
7.See the Excel functions: RANK, COUNTIF, MATCH, UNIQUEVALUES (Excel Add In MoreFunc), COUNT, SUM
8.More





Got a Question? Ask it Here in the Forum.