Thread: find smallest positive number among datas
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default find smallest positive number among datas
Try the below to return the max positive from Col A

=MAX(0,A:A)

--
Jacob


"Cerberus" wrote:

How to find the smallest positive number among datas in Excel?
Reply With QuoteReply With Quote