Formulas
Closed
Red hunter
Posts
3
Registration date
Sunday 16 December 2012
Status
Member
Last seen
16 December 2012
-
16 Dec 2012 à 16:08
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Dec 2012 à 16:24
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Dec 2012 à 16:24
Related:
- Formulas
- Little alchemy formulas - Guide
- Spreadsheet formulas - Guide
- Excel formulas across sheets - Guide
- Excel recalculate formulas - Guide
- Excel show formulas shortcut - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Dec 2012 à 16:24
16 Dec 2012 à 16:24
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.
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.
