Thread: Finding the MIN value, but greater than zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Finding the MIN value, but greater than zero
Try

=MIN(IF(F174:F188 0,F174:F188))

Enter with Ctrl+Shift+Enter NOT just enter

Mike

"Glenn L." wrote:

I need to find the minimum value in a data range (F174:F188), but greater
than zero. I tried "=MIN(F174:F1880)" and it does not work. How can I do
this?
Reply With QuoteReply With Quote