| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Smallest positive value
Can someone help me with a formula that will return the smallest positive
value in a given unsorted range? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Smallest positive value
=if(countif(a1:a10,""&0)=0,"no value",min(if(a1:a100,a1:a10)))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can only use the whole column in xl2007. danpt wrote: Can someone help me with a formula that will return the smallest positive value in a given unsorted range? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Smallest positive value
Hi, Dave
Great help again. Many thanks "Dave Peterson" wrote: =if(countif(a1:a10,""&0)=0,"no value",min(if(a1:a100,a1:a10))) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can only use the whole column in xl2007. danpt wrote: Can someone help me with a formula that will return the smallest positive value in a given unsorted range? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1st smallest, 2nd smallest,3rd smallest | Excel Discussion (Misc queries) | |||
| Looking for the smallest number that isn't less than zero | Excel Worksheet Functions | |||
| Finding Smallest Value | Excel Discussion (Misc queries) | |||
| next smallest | Excel Discussion (Misc queries) | |||
| smallest | Excel Worksheet Functions | |||
Linear Mode
