See also: VoseSortA, VoseSortD

VoseRank({data}, descending)



Example model-1, Example model-2

This array function returns an array with the ranks of the values from the input array. By default, the ranks in the list are sorted in ascending order, meaning that rank 1 is given to the lowest value.

When duplicates occur in the data, all of them are assigned the average of their ranks (which is more correct than Excel's RANK function that assigns the highest rank.)

  • {data} - the data of which the ranks are to be determined.

  • Descending - optional boolean parameter. Set FALSE (default) for ascending ranks, i.e. 1 = lowest data value. Set TRUE for descending ranks, i.e. 1 = highest data value.

When the output array is smaller in size than the {data} array, say n cells, only the ranks of the first n values of the input array are returned.

When the output array is larger in size than the {data} array it will return the ranks and fill up the remaining part of the output with #N/A errors.



Monte Carlo simulation in Excel. Learn more

Spreadsheet risk analysis modeling


Adding risk and uncertainty to your project schedule. Learn more

Project risk analysis


Enterprise Risk Management software (ERM)

Learn more about our enterprise risk analysis management software tool, Pelican

Enterprise risk management software introduction


For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now


For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now