Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 5. Performance Ranking > mmRANK

Business Formulas

mmRANK

Category: Reporting > Ranking

mmRANK is an improvement over the standard Excel Rank formula. mmRANK can emulate the Excel Rank function, moreover, it can ignore ties, it can assign middle value to ties, and it can rank results in an ascending or descending order.

Syntax

mmRANK(Input_Number, Database, Rank_Method, Optional Rank_Ascendent)

Input_Number The value to be ranked
Database The whole set of data to rank the Input_Number against
Rank_Method 1 = Emulates the Excel RANK formula 2 = Ignores ties 3 = Assigns middle value to ties
Rank_Ascendent Optional - If not BLANK ranks are in descending order, e.g., the higher the price the lower the rank; otherwise ranks are in ascending order

Example

See example file Business Formulas.xls, sheet mmRANK.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmBASS
  • mmCSII
  • mmCSIW
  • mmDBAVG
  • mmDBCOUNT
  • mmDBSUM
  • mmDW
  • mmEI
  • mmHERF
  • mmINTERPOLE
  • mmMAD
  • mmMAPE
  • mmME
  • mmMSAR
  • mmMSE
  • mmPERFCV
  • mmPERFO
  • mmPERFR
  • mmPERTSD
  • mmPERTT
  • mmPERTVAR
  • mmPREMIUM
  • mmRMSE
  • mmSEASON
  • mmU
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: