RANK

Finds the rank of the value in the range.

---

FORMAT: RANK ( value IN reference..reference order)

---

DEFINITIONS:

• reference: column number or column title, row number
• value: a number to search reference..reference for
• order: LARGEST or SMALLEST depending on what you want the rank to represent. The value is optional and will default to LARGEST

---

EXAMPLE 1:

rank (2 in 2,1..4,3 largest)

Returns the rank of a value of 2 (where the largest value would be rank 1) in the cell range between column 2, row 1 and column 4, row 3

EXAMPLE 2:

rank ( 1, "column1",1.."column1",5 )

Returns the rank of a value of 1 from all cells between rows 1 and 5 in the column titled “column1”

EXAMPLE 3:

rank ( 2, "column1",4.."column2",9 smallest )

Returns the rank of a value of 2 (where the smallest value would be rank 1) of all cells between “column1", row 4 and “column2”, row 9