emp

  1. S

    Need formula for Point spread

    Need a formula for the following: Sales goal 77% 300 points to spread amongst 4 employees based on results Emp #1 Actual - 83% Emp #2 Actual - 80% Emp #3 Actual - 78% Emp #4 Actual - 69%
  2. K

    Automatically update Main Sheet from 3 or more other Sheets

    Hello, I need help to update Main sheets from other Sheets Example Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salay </tbody> Sheet1(Jul-19) How will automatically Emp ID & Name updated in Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salary 01...
  3. S

    Optimized scheduling to demand based on constraints

    The title kind of states my goal. I am looking for some help to get started to solve the problem of scheduling a group of people based on demand and their individual constraints, using solver and VBA (or maybe a combo of the two?) Here is a picture to describe what I am looking for help to...
  4. T

    Simple IF and/or question

    Good day to all. I have a table with multiple conditions with specific amounts if conditions are met, but Im stymied on how to create the IF and/or formula since the conditions have min/max ranges. Hoping for some help :( Thanks a lot! Sample table below: <style type="text/css"><!--td {border...
  5. 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...
  6. G

    Analyze organizational level per incumbent

    I have been racking my brain and gotten stuck. I have a list of ids. Each id has the manager that incumbent report to. The list is from CEO down to bottom of org including every employee. (~46k rows) The list is in no particular order. What I would like to do is analyses on what level each...
  7. A

    Sum IFs on Multiple Criteria, one is shared

    Hope my title makes sense. So, I have a couple sheets of data. On one of the sheets is an employee Number, which I am using vLOOKUP to attach the name to that employee.. It is then SUMIFs, some data from another range based on that range (Employee Name). The problem is that a few employees...
  8. K

    Countif from a closed workbook

    Hi, Is it possible to apply countif formula from a closed workbook? I have one open excel workbook Data.xls which has emp id in cell A2 of sheet1. Another excel workbook name Conso.xls is in a shared drive folder which has emp ids in column B. I want to check how many times one emp id is there...
  9. H

    Change Cell Value One by One and Call Macro Automatically

    Hi Experts, I have a template which runs on macro. This template is used to prepare n save as file, where i have to manually enter Emp ID one by one and RUN the code to save file separately. Is thier a possibilty to load Emp ID from Sheet 1 (Column A of Database TABLE) to Sheet 2 (Column A2 of...
  10. A

    Employee Summary sheet

    I have a sheet of daily manpower attendance. I need to prepare summary sheet with criteria of 1. Category (category to be listed in the summary sheet and mentioned in the attendance sheet) 2. Date (1 cell in summary sheet will be denoting date; so when I change this date, automatically the...
  11. D

    Nested if formula not working

    Hello Everyone, I'm trying to use the following formula: <code> =IF(P31=T31,"No-Affiliate bill code = Emp bill code",IF(P31<>T31,"Yes-See Column Q",IF(ISNA(VLOOKUP(K31,'Company Employee Codes'!$B$2:$B$198,1,FALSE)),"No-Account has the correct Emp bill code",0)))</code> The first two are...
  12. X

    Retrive First and last occurrence between specific time intervals

    Hi Experts, I have data like the table below, where I want to fetch time (Column C) when the Emp Code 843567 swiped his card on 05/23/2018 for first and last time between time interval 6:00 AM and 3:00 PM. <tbody> EMP Code DATE CARD SWIPE TIME 843567 05/23/2018 6:10 AM 674593 05/23/2018...
  13. C

    Grab Employee names based on schedule

    Hey Everyone, I have a rather large and probably complex sheet I am working on. It is(or will be) comprised of weekly schedule with a row for each hour of the day and column for each day. This will be a 24/7 schedule. The plan is for the schedule to automatically populate the names of by...
  14. M

    VBA Run-time error 424

    Hi everyone, I am having some issues with this marco, and full disclosure, I don't know much about macro's at all. But i am getting a runtime 424 error whenever i try to run this. The purpose is to pull from a list of employee numbers and print them on a safety inpection sheet. Any help is...
  15. W

    Count Attendance for People On Certain Dates

    I think this would be a COUNTIF combined with a INDEX MATCH MATCH. -1 book -2 worksheets Input sheet from Call Report (this is counting attendance for conference call) <tbody> DATE PERSON ID 4-14 1 4-14 2 4-16 1 4-16 3 </tbody> What I want it to auto populate <tbody> Date Emp 1...
  16. F

    how to highlights the same value with duplicates in another column

    i have multiple employee with the same employee number in column A and a code in column b. how can I highlights the same value with duplicates in column B. Ex: Col A | Col B 1001 code1 1001 code2 1001 code3 1001 code1...
  17. K

    VBA - Print to PDF with file name from a cell

    Dear All I am new to VBA. I have the below code which is a printing loop to a specific number specified in Cell A2. Sub PrintLeveCal()' ' PrintLeveCal Macro ' ' Emp = 1 Do While Emp <= Sheets("Invoice").Range("A2").Value Sheets("Invoice").Select Range("A1").Value = Emp...
  18. S

    VBA Sum & Combine Data

    Good morning I have a large data set approx 100,000 rows. I need to sum and combine the data based on Emp ID and DEPT only if they are the same. If the Emp ID and DEPT are not the same then leave it be. There will always be a Cur or Re in Column (S) The data must be Combined and summed in Cur...
  19. R

    Selecting latest date in a list with multiple objects

    Good morning, The way our planning system is set up, it creates a brand new record for an employee if they move departments. The first record will have an effective end date on the date of the transfer and the second record will have an effective start date on the same day. Normally, if they do...
  20. N

    Index Match False

    Hello, I'm using a formula found on the internet for a call center Shift bid. It looks it should work I get a #NA message when you execute the formula. I'm getting a at #NA ISNUMBER(MATCH(B3:H3,I$2:I2,0)). The numbers in b2 represent a shift number. The goal is to find the first choice out...

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