min function - help

  • Thread starter Thread starter Michael
  • Start date Start date
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,
 
=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,
|
 
Back
Top