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


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top