MIN match value above zero

[mailrail]

I'm trying to match a value ABOVE ZERO in column B with an office name in
column A. How do I sort out and ignore any zero values?

 

[Don Guillett]

try this array formula which must be entered using ctrl+shift+enter
=MIN(IF(E1:E21>0,E1:E21))

 

[mailrail]

Thanks Don. Worked liked a charm.

try this array formula which must be entered using ctrl+shift+enter
=MIN(IF(E1:E21>0,E1:E21))

 

[Don Guillett]

glad to help