Trying to find a way to parse out data when record falls between another record. Example on 12/10/18 - Kevin time is doubled on that day....one foreman entered his time from 8-4 and another foreman entered his time from 10-2. Since it is doubled up, I need to highlight that error. Tried...
Hello,
I have a unique question. I am trying to auto populate data (resource needs) between two dates in excel. For instance, each month from January 2015 (start month) to December 2017 (end month) I need 5 resources. Jan 2015=5 resources, Feb 2015=5 resources, and so on all the way to...
I have a list with three columns. One has the min weight and the other the max wieght. I want to find the easiest way to return a value on a third column cost.
So if i were to enter 221 it would return $14. I found a similar problem with a vlookup solution but that lookup value was one or the...
hi, I hope someone might be able to help me formulate a simple bonus payment spreadsheet!
I am trying to fathom "less than greater than" syntax in a formula without much success...!
In simple terms I am trying to find a formula that says:
In n27 i need a formula "if n26 (total revenue)...
Hello,
It would be great if anyone could help me =]
So sheet 1 has a list of chemical codes and next to each chemical code shows its corresponding quanityt. I want cell A2 in sheet 2 to look at A1 of sheet 2 (a specific year: 2007), and if this is the correct year then I...
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.