| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pick the low number in a column of Numbers
I have a column of numbers that are the results from formulas. in the absence
of enter values, the results column (say D) show several zeros. I use =min(d1:d16) placed in column E to return the lowest value in the colunm D which is ussually zero. What I want to do is ignore the zeros and pick the lowest numer that is not 0. =IF(e12<=0,e12,SMALL(d5:d12,2)) works for a column of negative numbers, because they are all less than zero. I can't seem to get the formula right For Positive integers. Help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| randomly pick a number from a set of predetermined numbers | Excel Discussion (Misc queries) | |||
| How do I pick the only number in a column and copy it to another? | Excel Discussion (Misc queries) | |||
| How do I pick the only number in a column and copy it to another? | Excel Discussion (Misc queries) | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Possible to pick out the lowest eight numbers in a row? | Excel Discussion (Misc queries) | |||
Threaded Mode
