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!!

Hello I am trying to write an If/Then statement. Here is the data.
 

Why not just use a pivot table? Select Data - Pivot Table and then follow
the wizard. Place the Dates across the top, the employee types down the left
sid and then put the numbers in the middle.
--
HTH...

Jim Thomlinson


"jdamron" wrote:

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!!

Hello I am trying to write an If/Then statement. Here is the d
 

Ok, I have never tried or worked with a pivot table. I have always used
formulas. But the If/Then has me stumped.

I will try that.

Thanks!!

"Jim Thomlinson" wrote:

Why not just use a pivot table? Select Data - Pivot Table and then follow
the wizard. Place the Dates across the top, the employee types down the left
sid and then put the numbers in the middle.
--
HTH...

Jim Thomlinson


"jdamron" wrote:

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!!