Bob -- I tried substituting MIN (for low bid price) for MAX
But get 0's in E2:E10; What's going on?

Range Below (in my example) A1:C10 << my formulas are in Column E2:E10
Item Supplier Price
pen Abb 1.90
pen Cad 2.00
pen Ham 1.95
Book Cad 3.20
Book Ham 4.50
Book Abb 3.50
Book Jal 3.10
Ink Abb 21.50
Ink Bom 21.00


"Bob Phillips" wrote in message
:

=$C1=MAX(INDEX(($A$1:$A$1000=$A1)*$C$1:$C$1000,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TUNGANA KURMA RAJU" wrote in
message ...
I have range A2:C10000 as
item--------------Supplier----------Price
col A---------------Col B------------Col C
pen ----------------Abb ------------1.90
pen ----------------Cad ------------2.00
pen ----------------Ham -----------1.95
Book---------------Cad -------------3.20
Book----------------Ham -----------4.50
Book ---------------Abb -----------3.50
Book ---------------Jal ------------3.10
Ink ----------------Abb------------21.50
Ink -----------------Bom-----------21.00
What formula is to be used in Conditional format to get lowest bid price
of
each item and the supplier(Col B & Col C) .