Eliminating 0 values when using the Small formula

  • Thread starter Thread starter MIchel Khennafi
  • Start date Start date
M

MIchel Khennafi

Good morning:

I have a range of numbers that contain the value 0...

For instance assume each number is in a cell: 0,100,0,800,200,0,150,80

How could I write the SMALL formula to have 80 as the smallest value instead
of 0?

Thanks
 
Based on your sample with all values being positive:

=SMALL(A1:A8,COUNTIF(A1:A8,0)+1)

Or, array entered using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=MIN(IF(A1:A8>0,A1:A8))

Biff
 
Back
Top