supervisor

  1. C

    Power Pivot Date Join

    I have 3 tables, One is a workorder table that has the due date of some 300 workorders (obviously dates are repeated) Second table is a supervisor table for dates that supervisors worked (again repeated dates) Third table is a calendar table I created through PowerPivot I am trying to merge...
  2. C

    DAX formula or PowerPivot connection?

    I have two tables one that shows all of my work order data and a column called due dates that a user manually updates to assign due dates to a given work order. I have another table called supervisor that has dates that supervisors worked, and any comments they may have added to the table...
  3. K

    List of all Direct and Indirect Reports by Supervisor ID

    Hi! I am really hoping someone can help me. I have a list of about 3,000 employees, with one supervisor ID tied to each employee ID. I need a list next to each supervisor ID that gives me all of their direct reports and their indirect reports. I wanted these ID's to populate in separate columns...
  4. S

    Pull unique values based on a different set of unique values (No macro)

    I am trying to create a list of unique values that relate to another list of unique values. Column A has a list of managers and column B has a list of supervisors that report to the manager in column A. There will be multiple supervisors that report to a mange, but no 1 supervisor will report...
  5. T

    Create list based on user selection from multiple drop down boxes

    I am trying to create a list on one worksheet based on data from another worksheet using two drop down boxes. I have a main spreadsheet that houses a list of operators, with their corresponding status (active, dropped, termed) and supervisor name. I would like to be able to select the supervisor...
  6. M

    Finding Latest Supervisor

    Hi All, I have a quick question regarding PowerPivot calculate column. I have below tables 1) Transactions <tbody> EMP ID EMP Name Sale Amount Sale Date Supervisor Name 1 xyz $1000 12/12/18 Sup 1 1 xyz $100 12/15/18 Sup2 </tbody> 2) HeadCount Table <tbody> EMP ID EMP NAme SUp Name...
  7. R

    Looking for a formula that locates specific text in range of cells are returns specific text value

    What I'm trying to build is a formula that will search a range of cells and return a specified text value if there's a match. Specifically I'm looking for names which may appear along a reports to hierarchy, 1-7. If the formula finds a particular name, any where in the range, I want it to...
  8. N

    Run BeforeClose Event in One Situation and Ignore or Bypass It In Another

    If anyone can help with code below it would be very much appreciated. I’m at loss as I’ve reworked the code below multiple times with no success. I’m trying to do several three things in sub but can’t get everything to work. Thing 1: I want to determine if person—supervisor or...
  9. W

    2 Lookups with date logic

    Good day, I have a workbook where one of the tabs contains tables that feed the lookup on other tabs. The situation that I need assistance with relates to the supervisor of an employee for tracking and statistics. Until recently, the table had the employee name, employee number and name of...
  10. W

    Another VBA Question

    Morning all I am looking for VBA to enable me to search my spreadsheet where the 'Grade' column is equal to 'APP' I have the autofilter as Sub check3() Range("A:1:X1").Autofilter6,"=APP" I know I may not need this, but want to leave it in, to let users see it has worked. What I am looking...
  11. A

    How do I come up with a formula to average cells?

    <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Manager Supervisor Manager Supervisor Manager Supervisor Average Daily work production 85 80 89 84.67 Accuracy of work 85 90 89 89 90 </tbody> Above scores is given by managers and...
  12. J

    Formula Help... Needed

    I am currently working with a list of 20K plus names. Each name has a "supervisor name" associated with it. However, I am trying to utilize this formula to show all people under specific supervisors when one is listed...
  13. J

    Proof of Concept

    Hi All i have a project that is outside of my current skill set. I'm not asking for someone to do it for me. sorry if this makes no sense. just want to make sure 1. if my idea is even viable 2. suggestions on possible area's issues may arise. 3. am i using the correct terminology. 4. people to...
  14. C

    How to associate an employee name with the name of their supervisor?

    Excel noob here. Each week I have multiple spreadsheets where my sole task is to alphabetize them by employee name and to manually insert their supervisors name next to them. This is incredibly time consuming for me. How can I make it so entering the employees name will yield their supervisors...
  15. K

    SUMIF with Names?

    Hello, I am looking to perform a SUMIF but with names. For example, say there are different supervisors in column A and I want to find the amount of agents a particular supervisor has listed in column B (without doing a filter). Say supervisor JOHN CLOUD is in Column A2 and then in random rows...

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