Ctrl/shift/enter =MIN(IF(A1:I1=0,"",A1:I1))

"realspido" wrote in message
...
I have big table with vendors, and I have to find the lowest price for each
item, but prices are like:
A B C D E F G H I
etc.
Item x 128 175 0 215

the problem is there are also columns with quantities which shouldn't be
included
I don't want to include columns e.g. B, D, F etc. AND find minimum price
but
0. so I can't use:
MIN(C1,E1,G1,I1...) because I'll get 0 as result.
I'm looking for the simplest solution.

Appreciate for any help.