Find the two lovest values

O

OM

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

Dodo

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 ?
Click to expand...

Use SMALL
 
M

Max

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