I want to know the 2nd lowest number in the following list.
I have tried using SMALL(X:X,2) but it returns 14.00 because there a two number 14's. The answer I want is 14.50.
Many thanks
14.00
14.00
14.50
14.50
15.00
16.00
16.00
16.00
16.00
16.00
16.00
16.00
16.50
16.50
16.50
16.50
17.00
17.00
17.00
17.00
17.00
17.50
19.50
20.00
Bookmarks