LARGE : General Usage
1
data
2
3
3
-0.5
4
23
5
7
6
1
7
8
9
Result
Formula
10
23
=LARGE(A2:A6, 1)
11
3
=LARGE(A2:A6, 3)
12
-0.5
=LARGE(A2:A6, 5)
13
#NUM!
=LARGE(A2:A6, 6)
14