Excel:  Find the ranks of numbers in your list

The Rank function returns the rank of a number in a list of numbers.  An obvious use for this function is for teachers to compare students' performances to each other, but there are many more applications for this handy function. RANK gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers. In our example, four numbers tie for the rank of 4, so there are no ranks of 5,6,or 7. Syntax: =RANK(number,ref,order)

• Number is the number whose rank you want to find.
• Ref is an array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.
• Order (an optional argument) is a number specifying how to rank number.
  • If order is 0 (zero) or omitted, Microsoft Excel ranks the highest number as 1.
  • If order is any nonzero value, Microsoft Excel ranks the lowest number as 1.