The RANK() function returns the rank or an argument compared to an ordered array of values. The syntax for the function is RANK (number, ref, order). The argument "number" can be numerical value or a reference to a cell which you want to find its rank in relation to the list.The "ref" is an array of values or reference to a list of values. The optional value "order" determins weather the list of data values is arranged into acending or decending order. Zero or no entry is for decending order (largest to smallest) and 2 is for acending order (smallest to largest). The RANK function can assess the vsalue of of arguments and organize into a list

How to use the RANK() function: Type " =RANK( " Enter the coordinate for a data cell in the list "A4". Type a comma. Enter the coordinastes for the range of values in the "data list" "A2:A10". Type a comma. Enter the "order" type. Type")" then press the "Enter" key.

The difference between RANK, LARGE and SMALL functions The LARGE function orders a list of values from largest to smallest, the SMALL function orders the values from smallest to largest. However the RANK function can returns the position number of a value in the list of data values in either decending or acending order depending on the parameters set by the user. Note: The RANK function ignores non numeric values in the array argument. Additionaly if the nth_ position entered into the function is larger than the number of elements in the array the function will return a #NUM! error.