View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
perplexed
 
Posts: n/a
Default can I use MIN function to find lowest, NON-ZERO or blank value?

I am trying to analyze a large block of data where not all columns have an
entry. I want to find the lowest value (but greater than zero or a blank
cell) and write it into a separate column.