$5.00

  1. M

    Need advice on a new spreadsheet that can show me best price from a particular supplier

    hi, I have multiple suppliers that I ask them to supply plumbing items that I choose at their best price. My trouble is the suppliers are becoming more eg. 10 suppliers. Each supplier can supply their 'own brand' of tap or Pipe Each supplier may have a different QTY for what they are...
  2. A

    VBA to Transpose Data and Loop

    Hello Excel Gurus, I'm trying to write a code that will transform my data from singular columns to multiple rows. My data is currently organized like this; <tbody> Index Budget View 1/1/2018 2/1/2018 3/1/2018 4/1/2018 123 Budget $10.00 $10.00 $10.00 $10.00 123 Forecast $10.00 $0.00 $5.00...
  3. D

    Sum a Column until desired amount then reset

    Need to the sum of Column E totaled until it is >= to a number (ie $5.00). Once that happens I need the difference over the (ie $5.00) to be calculated also and added to once it reaches a set number (ie $5.00). When complete I need the sum of column reset to $0 to start adding again to start the...
  4. D

    Syntax for IF THEN LOOKUP Formula

    I'm trying to get this formula to work =IF<gs id="5461d56c-5950-4f91-9baa-9b56a75f907c" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">(</gs>((LOOKUP<gs id="89f5118e-7bd1-4de8-b39f-6a37284babd3"...

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
Back
Top