MIN match value above zero
 

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?

MIN match value above zero
 

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

--
Don Guillett
SalesAid Software

"mailrail" wrote in message
...
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?

MIN match value above zero
 

Thanks Don. Worked liked a charm.

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"mailrail" wrote in message
...
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?

MIN match value above zero
 

glad to help

--
Don Guillett
SalesAid Software

"mailrail" wrote in message
...
Thanks Don. Worked liked a charm.

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"mailrail" wrote in message
...
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?