SMALL : General Usage
1
data
2
3
3
5
4
3
5
1
6
10
7
-2
8
4
9
10
11
Result
Formula
12
-2
=SMALL(A2:A8, 1)
13
3
=SMALL(A2:A8, 3)
14
3
=SMALL(A2:A8, 4)
15
10
=SMALL(A2:A8, 7)
16
#NUM!
=SMALL(A2:A8, 8)
17
0.5
=SMALL({1.2, 0.5, 3, 7}, 1)
18