contractor

  1. R

    Integrate automatic journey time into excel formula

    Afternoon guys I use Excel 2016 to produce costing sheets for projects, and I'm trying to figure out if I can get excel to automatically work out how far each customer is from a preset location e.g. a contractor. Any ideas on how to achieve it? Not sure whether it needs to be a super-techy...
  2. K

    VBA to save File to Folder of Current Month

    :confused: Hello All, I have a VBA that will save the current workbook to a folder for the current year and month. It will first check to see if the folder already exists and if it doesn't it will create it prior to saving. My problem is that I created my folder structure using the month...
  3. N

    Sum of values based on specific text

    Hi all, hoping this is a nice easy one. I have a list of contractors in column U (they appear more than once). I have an invoice value for each transaction, set against these contractors in column X. Does anyone know a formula to COUNT up the total value per contractor? i.e. the value for AAA...
  4. K

    INDEX MATCH to search two different columns and return value

    I'm trying to write a formula that will return a value from another sheet. My Main Table has a list of project numbers that I need to fill in the assigned contractor name from another sheet. The problem is that there are two project numbers (categorized as F1 & F2) on each row in different...
  5. A

    Multiple if statement with vlookup

    Hi, I have this formula below where I would also like to add if B3 = "3rd Party", then have the same result as Contractor, I've clearly failed trying AND/ OR functions. Please could you help? =IF(B3="Contractor",VLOOKUP(C3,'Rate Card'!A:M,13,0),VLOOKUP($B3,'Payroll by Person Mar-18'!A:M,13,0))...
  6. S

    Find out the Latest revision of the document

    Hi everyone, I need your expert advice for below I have a sheet of all the document number listed in Column A, Title in Column B, and Revision in Column C Document number will be same for all the revision coming Hence I want to track the exact current revision of the document Below is the...
  7. K

    Advanced Function To Compare Two Excel Lists

    Good afternoon, was curious if someone could assist me. I am a payroll administrator and use excel quite often and looking to be more efficient. What I am specifically looking for assistance with is my weekly payroll count. I have a template with my contractor names in one column and next...

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