LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Hello I am trying to write an If/Then statement. Here is the data.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I write a compound if statement? Diane Excel Worksheet Functions 5 May 17th 07 08:52 PM
how do I write an IF/other statement to cut off time data? Daren Excel Worksheet Functions 15 November 2nd 06 11:49 PM
How do you write an if statement that replaces #DIV/0! with 0 caliskier Excel Discussion (Misc queries) 6 March 10th 06 03:22 AM
how do I write the date in an if statement Susan Hayes Excel Worksheet Functions 1 August 23rd 05 09:29 PM
How to write a statement about if then Baffle, Atlanta, Ga Excel Programming 2 May 19th 05 07:20 AM


All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"