subcontractor

  1. A

    Swapping Named Cell Ranges Using Drop Down List

    I have searched all through google and cannot seem to find vba code to get me to what Im trying to accomplish. I have named the following groups of columns by going to Fomulas, then Define Name. Columns V:AB are named "Position_1" Columns AC:AI are named as "Position_2" Columns AJ:AP are named...
  2. S

    Help me! Pivot Table Failures...

    Good day Mr. Excel community, I'm hoping you can help me reorganize my data to suit my needs. Here's what I have... A list of subcontractors (Column B) with the bid package they have been invited to (Column A). I've pasted a small portion of this list below, but it includes over 400...
  3. P

    Sumproduct help

    Hi All, hoping someone can help me out again? I have a small table of rates that i can use INDEX or SUMPRODUCT to find a specific rate based on the role and subcontractor. I have another column of hours that i would like to use this rate on. Next to the hours column is another column that...
  4. B

    Help needed adding the last bit to a formula

    hi All, wondering if someone could help me out in figuring out the last part (I hope) to a formula. I have the below formula which returns the correct information however I would like it to add a figure to the end of the text. this formula =IF(W2="(Subcontractor)",K2& " (Subcontractor)")...
  5. B

    Help needed adding the last bit to a formula

    hi All, wondering if someone could help me out in figuring out the last part (I hope) to a formula. I have the below formula which returns the correct information however I would like it to add a figure to the end of the text. this formula =IF(W2="(Subcontractor)",K2& " (Subcontractor)")...

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