number,ref,order!This function is available for compatibility with Excel 2007 and earlier. Returns the rank of a number in ...

!number,ref,order!!This function is available for compatibility with Excel 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!