B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
Rank Function
0
E
9
60
D
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Rand function returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list.
27
28
Change the scores of the students and see the Rank change
29
30
31
This example is contributed by www.xlmacros.com
32
33
34
Copyright.
Anthony's VBA Page.
35
36
37
38
39
40
41
42
43
44
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.