Eliminating 0 values when using the Small formula
 

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

Eliminating 0 values when using the Small formula
 

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:A80,A1:A8))

Biff

"MIchel Khennafi" wrote in message
...
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