NC

[NC]

Hi all
can anybody please tell me how i can get the second minimum number from
the range

Regards
NC

 

[Ron de Bruin]

Try this NC

=SMALL(A1:A10,2)

 

[NC]

hi all
sorry guys
i got to know that i can do this by using "small" function.
so do not take trouble to reply this message

Regards
NC

 

[JE McGimpsey]

One way:

=LARGE(rng,2)