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
|