Formulas
Closed
Red hunter
Posts
3
Registration date
Sunday December 16, 2012
Status
Member
Last seen
December 16, 2012
-
Dec 16, 2012 at 04:08 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 16, 2012 at 04:24 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 16, 2012 at 04:24 PM
Related:
- Formulas
- Little alchemy formulas - Guide
- Spreadsheet formulas - Guide
- Ms excel marksheet formulas pdf - Guide
- Excel formulas number to words - Guide
- Excel recalculate formulas - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 16, 2012 at 04:24 PM
Dec 16, 2012 at 04:24 PM
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.