This Excel tutorial explains how to use the Excel RANK function with syntax and examples.
The Microsoft Excel RANK function returns the rank of a number within a set of numbers.
The syntax for the RANK function in Microsoft Excel is:
RANK( number, array, [order] )
The RANK function can be used in the following versions of Microsoft Excel:
The RANK function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel RANK function examples and explore how to use the RANK function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following RANK examples would return:
=RANK(A4, A2:A6, 1) Result: 5 =RANK(A4, A2:A6, 0) Result: 1 =RANK(A3, A2:A6, 0) Result: 4
(scroll to see more)