One way ..

Assume A1:A10 contains 10 different numbers

Put in B1: =SMALL($A$1:$A$10,ROWS($A$1:A10))
Copy B1 down to B10

B1:B10 will return a full ascending sort of what's in A1:A10
i.e. the smallest number in B1, the 2nd smallest in B2 and so on ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"OM" wrote in message
...
Hi, I am trying to make Excel find the two lovest values in a range off
numbers.
I can use the =MIN() for the lovest, but how about the next lovest ?

/Ole/