Thread: Lowest number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default Lowest number
Pete_UK wrote...
Try this array* formula:

=MIN(IF(A1:A9<0,A1:A9))
....

While this array formula may be more efficient, this can be done
without array formulas.

=LARGE(A1:A9,COUNTIF(A1:A9,"0"))

Reply With QuoteReply With Quote