Find the nth smallest number

This shows you how to find the second smallest value
=SMALL(A1:A10,2)

This shows you how to find the fourth smallest value
=SMALL(A1:A10,4)

This shows you how to find the third smallest value, ignoring any duplicates
{=SMALL( IF( ISNUMBER( B2:B10), IF (ROW (B2:B10) = MATCH(B2:B10, B2:B10, 0), B2:B10) ), 3)}

Related Formulas

Find the nth smallest number with 1 condition