=$C1=MIN(IF($A$1:$A$10000=$A1,$C$1:$C$10000))


"TUNGANA KURMA RAJU" wrote:

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