ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - NC (https://www.excelbanter.com/excel-discussion-misc-queries/9755-nc.html)

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)

--
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

JE McGimpsey

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

All times are GMT +1. The time now is 07:22 PM.