Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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/ |
#3
|
|||
|
|||
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/ |
#4
|
|||
|
|||
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 -- |
#5
|
|||
|
|||
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/ |
#6
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
How do I find the two lowest values in a range? | Excel Worksheet Functions | |||
in excel, how do I find which values doesn't have a pair? | Excel Discussion (Misc queries) | |||
To find different values in Col B corresp. to repeated vaues in c | Excel Worksheet Functions |