Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
new staff
I have four columns which relate to hiring new staff -
column A - the name of an employee (this name can appear more than once) column B - the name of the task they will work on column C - the start date for the task column D -- the category of person they are. ie. driver, dispatcher, legall, accounts etc. I would like to construct a table that extracts the following information: How many new people in each month will start in our company. If the name appears for a task starting in May and again for task starting in August - I only want them counted as starting in May. How many different categories of person are hired in each month - basically splitting teh above info into categories. Any help appreciated. Thanks, Ellebelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a simple staff roster | Excel Discussion (Misc queries) | |||
Staff availability worksheet | Excel Discussion (Misc queries) | |||
Staff Rosters. | Excel Discussion (Misc queries) | |||
how many staff have 1 skill, how many staff have 2 skills, etc. | Excel Discussion (Misc queries) | |||
Allocate workload evenly to different staff | Excel Worksheet Functions |