Find the two lovest values

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

[Dodo]

"=?Utf-8?B?T00=?=" <OM@discussions.microsoft.com> wrote in news:D903DF2B-
7EF7-4F51-A289-BB82D02C292F@microsoft.com:

> 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)

[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 ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"OM" <OM@discussions.microsoft.com> wrote in message
news:D903DF2B-7EF7-4F51-A289-BB82D02C292F@microsoft.com...
> 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/

[Max]

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

[OM]

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/

[Max]

You're welcome !
Glad to hear that ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"OM" <OM@discussions.microsoft.com> wrote in message
news:833DE838-E253-4F34-92E3-560FF11CCAB9@microsoft.com...
> Thank you, works fine.
>
> /Ole/