Here we go. Assuming ur data are in A1:D21 inluding header on row 1.
First, create list of employee numbers starting on A26 down to Axxx.

Formula for effect-date:
=INDEX($B$2:$B$21,MATCH(A26,$A$2:$A$21,0),0)

Formula for end-date:
=IF(INDEX($C$2:$C$21,MATCH(A26,$A$2:$A$21,1),0)=0; "";INDEX($C$2:$C$21,MATCH(A26,$A$2:$A$21,1),0) )

Formula for Job-Bonus Code:
=INDEX($D$2:$D$21,MATCH(A26,$A$2:$A$21,0),0)

Copy all three formulas down to get result for each head.

HTH
"JRussell" wrote:

Okay, Here is a sample of my data.

EMPLOYEE EFFECT-DATE END-DATE Job-Bonus Code
75013 6/27/2005 6/30/2005 BY-MIY-15
75013 7/1/2005 12/31/2005 BY-MIY-15
75013 1/1/2006 6/30/2006 BY-MIY-15
75013 7/1/2006 12/31/2006 BY-MIY-15
75013 1/1/2007 6/30/2007 BY-MIY-15
75013 7/1/2007 12/31/2007 BY-MIY-15
75013 1/1/2008 3/31/2008 BY-MIY-15
75013 4/1/2008 6/30/2008 BY-MIY-15
75013 7/1/2008 BY-MIY-15
750753 5/1/2004 5/15/2004 BY-L0A
750753 5/16/2004 6/30/2004 BY-L0A
750753 7/1/2004 12/31/2004 BY-L0A
750753 1/1/2005 6/30/2005 BY-L0A
750753 7/1/2005 6/30/2006 BY-L0A
750753 7/1/2006 12/31/2006 BY-L0A
750753 1/1/2007 1/7/2007 BY-L0A
750753 1/8/2007 6/30/2007 BY-L0A
750753 7/1/2007 12/31/2007 BY-L0A
750753 1/1/2008 6/30/2008 BY-L0A
750753 7/1/2008 BY-L0A


The desired result is
EMPLOYEE EFFECT-DATE END-DATE Job-Bonus Code
75013 6/27/2005 BY-MIY-15
750753 5/1/2004 BY-L0A



--
JRussell


"Alojz" wrote:

Hi, would be helpful providing us with the structure of ur data, otherwise we
might just guess. So, place here sample of source data and desired result. I
go sleep now but somebody else will help you soon or later.

"JRussell" wrote:

How do I create a summarize report of data that is date driven? For example,
I have a table of employee job history in which employees held the same job
for several years. I want to create a summarized report that will simply
give me the start date and end date for the employee at each change in job.
How do I do that?
--
JRussell