petethecat
Board Regular
- Joined
- Oct 25, 2011
- Messages
- 63
Hello All
I have a long list of course data from which i want to create a list of the courses that were available against a month that i pick. In turn this will enable me to create a graph against the month.
This is how the data looks at present (This is not the complete list!)
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=2></COLGROUP>
So what i want to do is say that the month is April (01/04/2012 to 30/04/2012) & create a list of courses that were available during that date range. I have tried Pivot tables but they aren't really doing what i want them to do! - though i have to say I am a TOTAL novice at pivot tables!
Any suggestions will be gratefully recieved
Petethecat
I have a long list of course data from which i want to create a list of the courses that were available against a month that i pick. In turn this will enable me to create a graph against the month.
This is how the data looks at present (This is not the complete list!)
Date of course | Name Of Course | Delegate Department | Planned number of attendees | Actual Number of Attendees |
02/04/2012 | Manual Handling | FC | 1 | 1 |
02/04/2012 | Manual Handling | CS | 2 | 2 |
02/04/2012 | Manual Handling | WC | 3 | 3 |
02/04/2012 | Manual Handling | Engineering | 4 | 2 |
02/04/2012 | Manual Handling | Process Tech | 5 | 5 |
02/04/2012 | Manual Handling | Quality | 5 | 1 |
02/04/2012 | Manual Handling | Customer Services | 1 | |
02/04/2012 | Manual Handling | CI | 4 | 4 |
02/04/2012 | Manual Handling | HR | 3 | 1 |
01/05/2012 | Leadership - managing performance problems | FC | 2 | 1 |
01/05/2012 | Leadership - managing performance problems | CS | 2 | 2 |
01/05/2012 | Leadership - managing performance problems | WC | 3 | 3 |
01/05/2012 | Leadership - managing performance problems | Engineering | 4 | 2 |
01/05/2012 | Leadership - managing performance problems | Process Tech | 5 | 5 |
01/05/2012 | Leadership - managing performance problems | Quality | 5 | 1 |
01/05/2012 | Leadership - managing performance problems | Customer Services | 1 | |
01/05/2012 | Leadership - managing performance problems | CI | 4 | 4 |
01/05/2012 | Leadership - managing performance problems | HR | 1 | 1 |
01/05/2012 | Fire Extinguisher Training | Admin | 1 | 0 |
02/05/2012 | Discipline & Grievance | FC | 4 | 3 |
02/05/2012 | Discipline & Grievance | CS | 9 | 8 |
02/05/2012 | Discipline & Grievance | WC | 5 | 4 |
02/05/2012 | Discipline & Grievance | Engineering | 3 | 3 |
02/05/2012 | Discipline & Grievance | Process Tech | 1 | |
02/05/2012 | Discipline & Grievance | Labs | 1 | 1 |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=2></COLGROUP>
So what i want to do is say that the month is April (01/04/2012 to 30/04/2012) & create a list of courses that were available during that date range. I have tried Pivot tables but they aren't really doing what i want them to do! - though i have to say I am a TOTAL novice at pivot tables!
Any suggestions will be gratefully recieved
Petethecat