number,ref,order!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the rank of a number ...

!number,ref,order!!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the rank of a number in a list of numbers: its size relative to other values in the list!is the number for which you want to find the rank!is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored!is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value!