=$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) .