Formulas

[Closed]
Report
Posts
3
Registration date
Sunday December 16, 2012
Status
Member
Last seen
December 16, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I ve forgotten some formulas used in excel. Please someone should with this formula used to set ranks eg, first, second, etc.


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
See this to refresh memory

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 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, Microsoft Excel ranks number as if ref were a list sorted in ascending order.