employees

  1. N

    IFNA VLOOKUP with multiple repeating table arrays with filter

    Hi all, I have an interesting issue I have been searching far and wide for a solution to no avail. I have 3 employees who are assigned tasks every week. They rotate tasks every week. There are about 30 tasks, but they change every week so one week tasks A, J L K need to be assigned and the next...
  2. M

    Plot dots on a bar

    Hi there! Please help :) I have a graph with salary range and I want to plot my employees as dots on a bar per grades accordingly. I think I did all right, but my dots (employees) appear on a right side of the graph and not on the bars ( salary range). Both Employees and salary range are primary...
  3. S

    IFS function issue...

    Hello everyone, I'm assuming this is the ideal function, but I could be way off. Issue on "data" page: Need name of employee (column E) to register a "Division" (e.g. Administrative, Maintenance, Shipping, Production) in another Cell (column W) On "Employees" page I have a the four "division"...
  4. S

    =ROUNDUP(RANK($C27,Rando)/Sizes,0) FORMULA

    I tried the formula below =ROUNDUP(RANK($C27,Rando)/Sizes,0) and it works great for a list of people. I need this formula to work for a group of employees rather than a list of names. My chart below shows a group of employees in each department. So 42 represents one department, 19 another group...
  5. S

    Formula help - pivot table did not solve my problem

    I have a list of managers (column A), a list of departments that are assigned to these managers (the amount varies) (column B), the final column contains the amount/values of employees in each dept (column C). The purpose of the list is to distribute it to 6 different people. I need 6 different...
  6. P

    Populating Manager IDs? Vlookup?

    Hey all, I've got this list of Employee ID - Employee Name - MGR ID - Manager Name. 1400 employees, ~400 managers. I'm looking for a formula or function or feature - SOMETHING that will allow me to populate the Manager ID. I know VLOOKUP would work if it was a 1:1 relationship but as the...
  7. K

    Tax Data for employees

    Trying to write a sheet to track employee pay for about 10 employees. I can figure out the hours worked easily enough. What is the simplest way to figue the employee share of fed and state taxes? All of our employees will earn less than 100k per year, but may have different with holding numbers...
  8. R

    Compute data in other cell if cell is blank

    Question: How many employees were promoted more than 7 months ago (Column C)? If they were not promoted, then how many employees were hired more than 7 months ago (Column B)? <tbody> Employee Hire Date Last Promotion Date Employee 1 <tbody> 09/12/2013 </tbody> 01/01/2018 Employee 2...
  9. S

    Macro to help me transpose this information?

    I searched for a similar situation to mine and didn't see one (apologies if one exists and I missed it!) I have to format a long list of managers and their employees for mass emails, and the lists I get from our database are: <tbody> Manager 1 Employee A Manager 2 Employee B Manager 2...
  10. D

    auto track CTO if an employee came in during a Holiday

    Hi All, Noob Here :) seeking help in auto tracking of employee's earned Compulsory Time off based on an employee's schedule.
  11. J

    Determination of the absence rate

    Hello everybody, I am currently trying to determine from the data model, how high the absence rate for the individual weeks or months. So far, I've just added the factor to the pivot calendar, whether it's a workday. The table with the presence or absence of the employees is structured as...
  12. B

    Hide/Unhide Row based on dropdown value

    Hi all, I'm extremely new to VBA and need assistance. I have 2 worksheets; Worksheet 1 has is a list of all employees in both department "A" & "B". Worksheet 2 is a list of employees from department "A" & their tasks for the day. I would like to create a VBA where I can enter all of my...
  13. G

    How to set up formula in excel

    Hello All, If anyone can you assist I would be greatly appreciate it. Ex.: I have a list of 10 Employees that do various jobs. Of those 10 employees, 3 employees cover the job of the person(s) on Vacation. The maximum number employees on vacations is 3. I would like to show (in a excel...
  14. P

    Variable autofilter

    Is there a way to set a filters criteria based on a list of variables? I have a master list of names of all employees. Some employees get reassigned to new areas on a regular basis. I get schedule updates from their supervisors each week. The list of employees by each area changes. What I'd...
  15. H

    Pull names with certain start times

    <tbody> NAME LINE SUN MON TUE WED THUR FRI SAT LEE 1 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 OFF OFF OFF OFF JOHN 2 4:45 13:15 4:15 12:45 4:15 12:45 4:15 12:45 4:15 12:45 OFF OFF OFF OFF JAMES 3 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 OFF OFF OFF OFF...
  16. N

    Separate out first and last name

    Hey all! I have a very long list of employees in which I need to extract their names into a consistent format. I'm using the below formulas with a 99% success rate, however employees with a suffix of "JR" or "II" (etc) are throwing a monkey wrench in the calculation. First...
  17. J

    Query All Employees Who Have Not Logged In for the Day

    Greetings! I have produced a query that shows only the names of employees who have not logged in. But, I want the query to also only give me the employees who have not logged in for the current date = Date(). How do I incorporate that into this query I have already produced : SELECT * FROM...
  18. G

    Merge multiple sheets/lists into single list. Excel mac 2016

    Hi There, I have a file template with a series of identical tabs containing tables as individual timesheets for various employees. I make one new file each week. Each employee has their own tab and different weeks we may have a new/different mix of employees. I need to take all the tabs that...
  19. N

    Is this beyond Excel's capabilities?

    Hi all! I have come here several times in the past to find excellent help with my spreadsheets but I am thinking that I may be looking for something beyond the scope of Excel. I have been asked to take over my department scheduling and I am looking for a solution that will replace the current...
  20. S

    Why am I getting an "Object required" Here?

    Why am I getting the following Error Message on the Below codes. Run-time error '424': "Object required" Public Sub NewIT() Dim Employees As ListObject Set Employees = ThisWorkbook.Sheets("Employees").ListObjects("Employees") Call ThisWorkbook.Worksheets.Add(After:=Employees.Parent...

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