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.