Find the two lovest values
 

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/

"?B?T00=?=" wrote in news:D903DF2B-
:

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 ?


Use SMALL


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

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/

Pasted the wrong formula, sorry:

Line:
Put in B1: =SMALL($A$1:$A$10,ROWS($A$1:A10))

should read:
Put in B1: =SMALL($A$1:$A$10,ROWS($A$1:A1))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thank you, works fine.

/Ole/

"OM" wrote:

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/

You're welcome !
Glad to hear that ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"OM" wrote in message
...
Thank you, works fine.

/Ole/