View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joie
 
Posts: n/a
Default minimum from various columns without zeroes

Hi! Just a question:

I was computing for the minimum, using =min(f16,k16,p16,z16) but the problem
is I don't want the minimum to equal to zero (I want to see the lowest
positive number from these columns instead of zero).

Is there a way not to include zeroes from these columns in looking for the
minimum?

Thanks a lot!