Hello,
I use the below code for my absence tracker which was kindly provided on here.
I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at:
Current 6 months Tab - All absence in the last 6 month rolling period from...
Dear Experts,
I intend to re-arrange the data generated by system. I am using Office 2010
Current Format:
Mat No Cost1 Cost2 Cost3
A 5 3 2
B 6 9 3
C 7 6 2
To be Format:
Mat No
A 5...
Hi Experts,
I am attempting to write an if statement that will read the contents of a cell, and based on this act appropriately.
Is this possible? It only needs to look for two conditions, so as follows:
If cell C4 Contains the word "evening" (
D5 = 5 + 2
)
Else If cell C4 Contains...
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.