View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson
 
Posts: n/a
Default minimum function

Hi cutyfurby,
this array formula worked for me to return the minimum of A1:A10...

=MINA(IF(A1:A10=0,"",A1:A10))

after typing the formula you must commit it using Ctrl + Shift + Enter

Ken Johnson