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...
: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...
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...
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...
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))...
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...
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 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.