I have an excel spreadsheet which I am trying to improve. One of the columns is based on whether a shift was a morning shift (AM) or an afternoon shift (PM). currently it is using a data validation and I have to pick from a drop down list. Is there a formula that automatically inputs either AM...
Hi,
I do hope somebody can help me. I have 2 sheets...
First Sheet
Section 1 Fred Bloggs 1001 1003 1005 1007 1009
Section 2 Amy Trams 1000 1002 1004 1006 1008
Second Sheet
1002 9.2 0.00% 1 <section name="" here="">1005 9.7 80.00% 2...
My personal computer has a weird quirk where the area of a cell border that I can interact with to drag-and-drop or autofill is smaller than on every other computer I have used excel on.
On other systems, when I click on a cell, I can easily click the border and drag the cell contents to...
If a company owns 15 locations across the country. They want to add new systems in each locations. Some locations require more than 1 system. Some of these locations are located in the South, NE, W and Midwest. the systems installed are as below:
South - 10 systems
NE- 1 systems
West - 5...
Hi, I am looking to utilize conditional formatting to color code a set of totals compared between 2 payroll systems. The one payroll system pays by the minute and will have the format 37:47 for example to show 37 hours and 47 minutes worked that week. The other payroll system rounds to the...
Hi
This may get complicated so please be patient with me. A management tool was developed to track staff performance. There are three tabs that my administrator will paste information into which is extracted from our different onlinr management systems. There is a tab that automatically...
Hello!
I have been researching this question for a while and don't know if I'm misunderstanding what I've read, or if my question truly isn't being answered... so, I'm hoping to try and explain it here and would love some help!!
I am using Subtotal to understand what Categories have highest $...
I've got an interesting problem, where 5 systems contain lists of companies with IDs, and the companies are supposed to be consistent across companies, but I believe they're not, i.e:
Company ID 123 may be "Tom Ltd" in the first system, "Adam Ltd" in the second system, etc for 5 systems, but the...
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.