staff

Hi all, I really need some help with this one, I have done some research online but struggling to find anything for what I need. In a sheet called "Data" I have some staff IDs in column H, with assessment results ("Pass","Fail") in column Z. I need to be able to track those staff IDs that have...

I am trying to fix a formula and am not having any luck, here is my current formula that is returning #Div/0!, =SUM(COUNTIFS(June!E:E,{"FBC","Maternal Child"},June!AV:AV,{"Patient is a retired MD, and has a good understanding of his course of care.","No concerns at this time.","Nursing staff is...

Good Morning, I have been searching for a couple of days and cannot seem to find the answer for my question. It seems like most are looking to exclude nulls. I am in the process of meeting with 200 managers regarding their 90 departments, which is 85000 rows of data. What I am showing is...

Hey How can i fix this problem in my new project? I have the following. Tables: Address_Table = contains addresses to staff Phone_Table = contains phonenumbers to staff Email_Table = contain email to staff Personal_Table = contain staff names and social sec number Anstallning_Table = contracts...

Hi there, I maintain aworkbook that has a sheet where the staff schedule is laid out in columns asfollows: A = Staffmember name B = MondayStart Time C = MondayEnd Time D = TuesdayStart Time E = TuesdayEnd Time etc., endingwith M/N for Sunday Start/End Times Anothersheet includes relevant...

Hi All, Am trying to work on formuala which will give me efficieny ratio but i also want to factor number of working hours into the formula which i am not able to do it . Please help me with the tips . Have pasted two tables i.e Table 1 and Table 2, First table shows the actual time taken for...

Hi again - So I am trying to compare lists. I have 3 workbooks that I am using. #1 - Has Mandated Classes with staff names #2 - Has training records for all staff (current and retired) #3 - Is a master reference workbook What I'm trying to do is In #1 - create a formula that will look...

Hi Maybe someone can point me in the right direction. I have a tab that I am using as a key (Award Abbrev) that I want to use to populate cells in another tab in the same workbook (Staff Details) I have created specific text in I2:I60 in "Award Abbrev" that on the corresponding row has values in...

I have a spreadsheet with employee information in tables which I would like to be able to populate in a different table from a drop down list of staff. The simplest way to show you what I need is if you look at the generic Microsoft 'Employee Attendance Tracker' here...

Morning all. I need advice on where to start with a project/idea I have had. I have an excel document which is a training matrix, which contains all the staff details for over 300 staff (that number is growing continuously). Each of the staff have a clock number which is in cell B8 downwards...

I have attempted to search for the answer to my issue but even though there seems to many posts similar, I have been unable to adapt any of the solutions provided to achieve my desired outcome. From the answers I have read it appears to be quite simple but being new to VBA I have been...

I'm banging my head against a wall here. Can anyone help? Bascially, I've got a structured table where the last x# columns are week ending dates for staff and the user will fill out hours in each column for each staff member. However, the trick is that each staff member may be on multiple...

Hello all I am trying all sorts with wildcard and I have not really used advanced filter but am in a muddle trying I have a dataset in a sheet called staff column A has Forename Column B has Surname Column C has staff ID no and Column D has dept I would like in a separate sheet called...

Hi All, I have a table with information, to indicate the type of calls being made and each staff name, however using a manual table i can find out who has made calls and who hasnt. Using a Pivot table i can find out who has made calls and have lovely graphs, what i cannot find out, is how do i...

I started a new job and inherited a roster of 500 employees. the woman who created it has two sheets in the book - one an alphabetical listing of the staff with the following 10 fields <tbody> NAME WKR # PHONE # POS. # ITEM #/CLASSIFICATION FUNCTION MAIL STOP# LANGUAGE...

Hi, My staff enter a numeric value into a cell. This value needs to start with 0 but some staff keep forgetting and just enter say 12345 as opposed to 012345 Can you advise how this is formatted so next time a value without the 0 is entered then leaving the cell etc will add it. Thanks

I have a WorkBook which produces weekly Time sheets for staff. The first 3 sheets are the 'Admin' sheets; Start (produces week date and number copied across all sheets in VBA); Dutys (reads the Duty number and copies hours and time on duty) and Blank Time Sheets. Each subsequent sheet is...

Hi, I need to create a new column that will show the number of staff per vehicle in order to do further calculations. Generally if they had the same amount of staff regardless if another vehicle showed up to the incident I would use a vLookup table however there are two conditions to the number...

Hi, I have an annual leave workbook that keeps holiday details for around 60 staff There is a worksheet for each of the 12 months where leave is entered - Staff members in Column A, other varying data in columns C:H, leave is captured in columns I:AN I have an additional sheet called...

I am trying to create a rota in excel to balance staffing. Trying to create a spreadsheet where each member of staff has a duty rosta with all people in the list. Any Ideas on where I would start? Thanks in advance. <tbody> Zone 1 - (1 Staff) Zone 2 - (2 Staff) Zone 3 - (2 Staff) Zone 4 -...