Prev: Skipping rows
Next: Conditionally format a cell using a list of data defined in a rang
From: UKMAN on 4 Mar 2010 11:59
Hi

I have a register (list) that has headings such as name, start date, end
date, course duration in days (4)
example is
Name Start Date End date Duration
Sid 25 Feb 2010 3 mar 2010 5
Sid 12 Mar 2010 16 mar 2010 3

As showed each name will have multipule lines as will attend many course.

What I need to do is consolidate the list to show how many days they
undertook training each month. The report has heading as below

Name Jan Feb Mar Apr etc
Sid 0 2 6


any and alll help grateful as don't really want to use a pivot table... :0

I am using 2007 but it has to be 2003 compatable :(

Cheers
From: UKMAN on 4 Mar 2010 12:10
sorry didn't think my orig question had been posted so this is a duplicate of
that.

"UKMAN" wrote:

> Hi
>
> I have a register (list) that has headings such as name, start date, end
> date, course duration in days (4)
> example is
> Name Start Date End date Duration
> Sid 25 Feb 2010 3 mar 2010 5
> Sid 12 Mar 2010 16 mar 2010 3
>
> As showed each name will have multipule lines as will attend many course.
>
> What I need to do is consolidate the list to show how many days they
> undertook training each month. The report has heading as below
>
> Name Jan Feb Mar Apr etc
> Sid 0 2 6
>
>
> any and alll help grateful as don't really want to use a pivot table... :0
>
> I am using 2007 but it has to be 2003 compatable :(
>
> Cheers
 | 
Pages: 1
Prev: Skipping rows
Next: Conditionally format a cell using a list of data defined in a rang