Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
eve_date Date sktype psi_qy
09-Jun-06 6/9/06 SET UP LEAD 1 09-Jun-06 6/9/06 SET UP ASSISTANT 1 09-Jun-06 6/9/06 SET UP LEAD 1 09-Jun-06 6/9/06 SET UP ASSISTANT 1 10-Jun-06 6/10/06 EVENT DIRECTOR 1 10-Jun-06 6/10/06 SET UP SPECIALIST 1 10-Jun-06 6/10/06 SET UP LEAD 2 10-Jun-06 6/10/06 SET UP ASSISTANT 2 10-Jun-06 6/10/06 FLORAL DESIGNER 4 10-Jun-06 6/10/06 ART DESIGNER 1 10-Jun-06 6/10/06 FLORAL ASSISTANT 2 10-Jun-06 6/10/06 STRIKE LEAD 1 10-Jun-06 6/10/06 STRIKE ASSISTANT 3 10-Jun-06 6/10/06 EVENT DIRECTOR 1 10-Jun-06 6/10/06 ART DESIGNER 2 10-Jun-06 6/10/06 FLORAL ASSISTANT 2 Then I need to have a spreadsheet that telle many how many of the different types of employees are working on a given day. Like this: 6/9/2006 6/10/2006 6/11/2006 6/12/2006 6/13/2006 6/14/2006 Event Director #NAME? Art Designer #NAME? Floral Designer #NAME? Floral Assistant #NAME? Set Up Personnel #NAME? Strike Personnel #NAME? Under each date column, I want it to tell me how many Event Directors are sheduled etc. Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I write a compound if statement? | Excel Worksheet Functions | |||
how do I write an IF/other statement to cut off time data? | Excel Worksheet Functions | |||
How do you write an if statement that replaces #DIV/0! with 0 | Excel Discussion (Misc queries) | |||
how do I write the date in an if statement | Excel Worksheet Functions | |||
How to write a statement about if then | Excel Programming |