Another way to try ..

Assuming data below is in A5:H7,
where BestBid is to be calculated in H5 down

----------------------------------------------------------------------------
--BestBid
1/2" Pipe 1.00 .02 .98 1.05 .05 1.00
..98
3/4" Pipe 1.25 .02 1.23 1.25 .05 1.20
1.20
1" Pipe 2.10 .02 2.08 2.17 .05 2.15
2.08

Put in H5, and array-enter:

=MIN(IF(MOD(COLUMN(B5:G5),3)=1,IF(B5:G50,B5:G5)))

Copy H5 down

This will return the required min NET price figures which are non zeros

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"seastheday" wrote in message
...
Here is a sample of what the sheet looks like. I want to write a formula
in
the best bid column which will look at the NET price from each of the
companies listed. Occassionally some companies may not bid on an item and
there NET price would be zero.

Company A Company B
BEST BID
List Discount NET List Discount NET
NET
Price Price Price Price
Price
1/2" Pipe 1.00 .02 .98 1.05 .05 1.00
..98
3/4" Pipe 1.25 .02 1.23 1.25 .05 1.20
1.20
1" Pipe 2.10 .02 2.08 2.17 .05 2.15
2.08

THANKS