# RANK Function

The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending or descending order. Let’s first look at the syntax then look at the following example.

### Syntax:

` =RANK (number, array, [order]) `
• number – The number to rank.
• array – An array that contains the numbers to rank against.
• order – [optional field] Rank in ascending or descending order.
• Order = “0” Descending order (Largest to smallest)
• Order = “1” Ascending order (Smallest to largest)
• Order omitted = Default order is descending “0
` =RANK(B3,\$B\$3:\$B\$8,0)  `

In the above formula, we identify the number as cell B3, “135000”. We want to find the rank of this cell against the array cells, \$B\$3-\$B\$8. Finally, we want to use Descending order, so we input “0”. When entered, Excel will return the rank for each sales person as shown.

### SPLIT FIRST and LAST NAMES

Split First and Last name This tutorial covers how to split first and last names in excel. Splitting First and