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

Regards
NC

Try this NC

=SMALL(A1:A10,2)



--
Regards Ron de Bruin
http://www.rondebruin.nl



"NC" wrote in message oups.com...
Hi all
can anybody please tell me how i can get the second minimum number from
the range

Regards
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

One way:

=LARGE(rng,2)

In article .com,
"NC" wrote:

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

Regards
NC