min function - help

M

Michael

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

Niek Otten

=SMALL(A1:A6,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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