View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MIchel Khennafi MIchel Khennafi is offline
external usenet poster
 
Posts: 9
Default 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