littlefish
New Member
- Joined
- Mar 6, 2008
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
I have a table which ranks employee training for: Excel, Word, PowerPoint, and Outlook.
Column A - has the employee completed training for all four Office programs? Y/N
Col B - employee name
Col C-F - ranks 1 through 4 each Office program according to employee proficiency (E, W, P, O)
I'm looking for two results tables for each Office training program:
Table 1 which shows employees who have had training (sorted by rank, then name) and whether or not they have completed all training.
Table 2 with names who have not had training in the specific Office program.
(These tables will update as training is completed.)
All input is welcome and very much appreciated. -LF
Column A - has the employee completed training for all four Office programs? Y/N
Col B - employee name
Col C-F - ranks 1 through 4 each Office program according to employee proficiency (E, W, P, O)
I'm looking for two results tables for each Office training program:
Table 1 which shows employees who have had training (sorted by rank, then name) and whether or not they have completed all training.
Table 2 with names who have not had training in the specific Office program.
(These tables will update as training is completed.)
All input is welcome and very much appreciated. -LF