Thread: Lowest Value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default Lowest Value

Del wrote:

Is it possible to use an Excel formula to return the lowest time value in a
row or range, but exclude 00:00 ?


=SMALL(IF(E9:E13<0,E9:E13,1000000),1)

If the range is E9:E13. This is an Array Formula, so enter it with
Ctrl+Shift+Enter.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.