min function - help
 

hi,
i would like to have the value of the number which is just larger than the
minimun in an array.
For example:
11, 14, 8, 7, 10, 18
the min here is 7
I would like a function that sort/choose at the same time to give me the
value 8.
Please help.
Thanks,

min function - help
 

=SMALL(A1:A6,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Michael" wrote in message ...
| hi,
| i would like to have the value of the number which is just larger than the
| minimun in an array.
| For example:
| 11, 14, 8, 7, 10, 18
| the min here is 7
| I would like a function that sort/choose at the same time to give me the
| value 8.
| Please help.
| Thanks,
|

min function - help
 

Thanks, thanks and thanks,


"Niek Otten" wrote:

=SMALL(A1:A6,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Michael" wrote in message ...
| hi,
| i would like to have the value of the number which is just larger than the
| minimun in an array.
| For example:
| 11, 14, 8, 7, 10, 18
| the min here is 7
| I would like a function that sort/choose at the same time to give me the
| value 8.
| Please help.
| Thanks,
|