price comparison

  1. J

    Building a price compression excel sheet. HELP! HELP! HELP!

    I'm looking for some help in building a price compression excel sheet. I recently accepted a job as a purchasing agent for a service tech company. We provide service to gas station pumps and POS (point of sale systems) at gas stations. We have multiple vendors and I would like to centralize all...
  2. A

    Need help creating a lengthy formula (or a macro)

    I have some data where I need to calculate the "best deal". I have the basic math worked out, I just need to find a way to implement it into an excel sheet or macro. Here is how my data is structured: minimum buy quantity, rate 1, rate 2, rate 3, company, order quantity ... item 1 1000, 5, 4...
  3. C

    compare prices in sheet AND HIGHLIGHT lowest and highesr Values then change my price

    Hi all I have struggled with this for days, Basically i need to compare competitors prices, and highlight top and bottom values in red and green Respectively.. Then wish to compare MyPrice(F) with Cheapest price(G). If (F) is Higher then (G)THEN select value IN(G) and reduce the value by 1%...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top