
Let's say you have name of
the employees
and their
sales in quarter one or names of students and their corresponding marks
arranged in a random manner and you wish to find out who had the higest
sales or which student attained the best marks. You can use the rank
function which can give you this informaion without sorting the data.
The syntax of the rank function can be
described as follows:
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
is 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 nonzero value, Excel ranks number as
if ref were a list sorted in ascending order.
In case you do not know how
to enter the different parameters required by the RANK function, our
Excel training video even explains that.
