formula for Conditional Format
If you want the Min, try
=$C1=MIN(IF($A$1:$A$10=$A1,$C$1:$C$10))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"TUNGANA KURMA RAJU" wrote in
message ...
Bob,This gave me highest bid price,I want lowest bid price.I changed the
formula with MIN but it is not giving desired results.
"Bob Phillips" wrote:
=$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) .
|