Price Comparison formula

  • Thread starter Thread starter TJC
  • Start date Start date
T

TJC

Acme XXX Price OOO Price Best Price
$46.21 $49.95 $46.21

I am looking to create a formula that will compare the three prices listed
and enter the lowest price header into the "best price" column.
 
Thanks, I tried this, but am actually looking to have the Best Price column
reflect the vendor name rather than the "best price". Thanks again for your
help!
 
Acme XXX Price OOO Price Best Price
$46.21 $49.95 $46.21

I am looking to create a formula that will compare the three prices listed
and enter the lowest price header into the "best price" column.
Click to expand...


First, make sure that the prices are numbers formatted as currency and
not text. Then you may try the following formula:

=INDEX(A1:C1,,MATCH(MIN(A2:C2),A2:C2,0))

This will list the header with corresponding to the lowest price.
If there are more than one header with the lowest price, as in your
example, the leftmost of them will be listed

Hope this helps / Lars-Åke
 
Hi, try

=IF(MIN(B6:D6)=B6,$B$5,IF(MIN(B6:D6)=C6,$C$5,$D$5))

I assume that your names are in row 5
 
With "Acme" in a1 and prices in a2:c2.
=INDEX(A1:C1,1,MATCH(MIN(A2:C2),A2:C2,0))

Will get the job done.
 
What would be the coad, assuming that the above code worked great with my system and i wanted to talk between pages.
what i want to do is find the less price on page one,
then on page two have an order guide.
the order gide would take have the same list of items in the same order as page one, but to its right i would have days of the week.
what i want to do is when i copy and past my weekely price list into page one for the three companys.
page two would pull the name of the company that was the lowest AND highlithg that Row or item a color that goes with that name like yellow.
like this
Page 1
(green) (red) (Yellow)
Samis A1A Produce guy
onions 19.20 17.80 22.20 A1A
17.80
potatos 20.15 18.20 16.50
Produce guy
16.50

Page 2
Buy from Monday tuesday wends
onions A1A (This Whole Row Red)
Potatos Produce guy (This Wole Row Yellow)


Is this possable?
 
What would be the coad, assuming that the above code worked great with my system and i wanted to talk between pages.
what i want to do is find the less price on page one,
then on page two have an order guide.
the order gide would take have the same list of items in the same order as page one, but to its right i would have days of the week.
what i want to do is when i copy and past my weekely price list into page one for the three companys.
page two would pull the name of the company that was the lowest AND highlithg that Row or item a color that goes with that name like yellow.
like this
Page 1
(green) (red) (Yellow)
Samis A1A Produce guy
onions 19.20 17.80 22.20 A1A
17.80
potatos 20.15 18.20 16.50
Produce guy
16.50

Page 2
Buy from Monday tuesday wends
onions A1A (This Whole Row Red)
Potatos Produce guy (This Wole Row Yellow)


Is this possable?
 
Back
Top