Rank Function

Question:     How do I return the rank of a number in a list of numbers relative to other values in a list?

Answer:        By using the RANK function in Excel. The function returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

Why:          To rank numbers in a given list so that one can easily determine the top performing product

Applies To: Excel (2010, 2007, and 2003):

1.         Refer to the data given below

2.         Select cell F3 and type; =Rank(E3,\$E\$3:\$E\$11)

RANK(number,ref,[order])

The RANK function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

Number   (Required.) The number whose rank you want to find.

Ref   (Required.) An array of, or a reference to, a list of numbers. Non-numeric values in ref are ignored.

Order   (Optional.) A number specifying how to rank number.

If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order.

If order is any non-zero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order

3.         Press Enter and copy the formula down

4.         The result will be the screen shot below