RANK : General Usage
1
data
2
2
3
-5
4
8
5
13
6
10
7
-18
8
23
9
26
10
11
12
value
type
Result
Formula
13
10
1
5
=RANK(A13, A2:A9, 1)
14
26
0
1
=RANK(A14, A2:A9, 0)
15
26
1
8
=RANK(26, A2:A9, 1)
16