leader

  1. S

    Delete 2 hour from out time

    Hi Friends, Everytime when I face any problem in excel this forum help me a lot. here my management take decision to minus 2 hour OT (Over Time) from every worker. When I minus their OT the out time will be decrease also e.i. 9:00:00 PM will be 7:00:00 PM. Here I give a list for your kind...
  2. N

    Multiple condition lookup

    Hi, this forum is awesome. I have researched my problem, and cannot find the correct resolution, so here goes: I need to be able to insert a employee hourly rate into a table. The employee hourly rate is identified by using a combination of 2 variables. Here is the source table with the roles...
  3. S

    Graph Ideas

    I need to show this on a graph, and I'm looking for ideas on how to best display it: When new person is hired, we pay them $15 per hour (example). But they require the help of HR, a Manager, a Team Leader, a Group Leader, etc. So they are really costin us, say, $500/hr (plus their labor...
  4. D

    COUNTIF Issues - Counting across columns

    All, I have struggling with a formula to use IF and AND. I have 3 columns in a table, Chain of Command 1, Chain of Command 2 and a Full Time/Part Time column. This list will be added to each week, so it will continue to grow. Based on a preselected Leader I have been able to get a count of...
  5. D

    COUNTIF AND Issues - Counting across columns

    All, I am having issues with a table that will have other data added daily. I have three columns where I have Chain of Command 1, Chain of Command 2 and FT/PT. Based on a pre-selected leader, I can get the count of how many times that leader chows up in the list using COUNTIF; however, I am...
  6. T

    How to consolidate records based on a key, and create semicolon delimited list from ID fields

    <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Hi, Would love some help, will buy first automation that works lunch! :) I am trying to go from List A like this: <style type="text/css"><!--td {border: 1px solid #ccc;}br...
  7. M

    Creating a Task Completion Summary sheet using formulas from a copy/paste dump

    <tbody> A B C D E F G H I 1 Monday Tuesday Wednesday Thursday - Completed Goal Percent 2 Leader 1 1 0 0 - 4 4 100% 3 Boss1 1 0 0 0 - 1 4 25% 4 Boss2 0 0 0 0 - 0 4 0% 5 Sheet 1 </tbody> <tbody> A B C D E F G 1 N/A N/A Submit Date...
  8. S

    Removing random variables appearing twice

    Hey guys! :) I have a strange and hopefully not to tedious problem regarding how to remove a random variable appearing twice. My task is to make a schedule for 7 people, where 2 will work on weekdays (One as a team leader and the other a reserve: On weekends there will be 2 team leaders & 1...
  9. 1

    Folder access dilemna

    Hi, I will try to explain the best I can. I have built a form and a report for our Call Centre team. Each CC worker has random calls monitored by a Team Leader. A form is filled in and saved to a folder in the Team Leader Team folder. I have a report that all CC workers can use to view...

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