Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
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 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.