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 |
Pick the low number in a column of Numbers
suppose u have values in range d5:d12 ...
Try this =SMALL(D5:D12,COUNTIF(D5:D12,0)+1) On May 29, 9:59*pm, boxarox wrote: 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 |
Pick the low number in a column of Numbers
Thanks for the speedy reply. Your formula works nicely
"muddan madhu" wrote: suppose u have values in range d5:d12 ... Try this =SMALL(D5:D12,COUNTIF(D5:D12,0)+1) On May 29, 9:59 pm, boxarox wrote: 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 |
Pick the low number in a column of Numbers
Maybe???
=IF(SMALL(D1:D16,1)=0,SMALL(D1:D16,2),MIN(D1:D16)) "boxarox" wrote: 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 |
All times are GMT +1. The time now is 06:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com