Excel Functions - a quick reference

SMALL Function: To fetch the 2nd smallest number from an array. SMALL(Range,n).

E.g. Range: A2:A10.

n=2
Result: Displays 2nd smallest number in the range from A2 to A10.