Good morning,
I am using excel 2010 and I have 2 sheets that I work with regularly. One is a list of staff, both current and past. This sheet is set up to filter out 'current' and other employees based on their employment status. The other is a sheet that I use to track all of the training they've completed .. again for both current and past employees. The sheet currently has about 1800 entries dating back to about 2000.
So now, I need to pull a report of who (of the current staff only) DID NOT complete one of the required courses in this fiscal year. Then I can let them know the course is being offered again.
I can print a nice little pivot table of who has completed the training, and on what dates the training was offered - but I need it to tell me also who has not.
any ideas?
I am using excel 2010 and I have 2 sheets that I work with regularly. One is a list of staff, both current and past. This sheet is set up to filter out 'current' and other employees based on their employment status. The other is a sheet that I use to track all of the training they've completed .. again for both current and past employees. The sheet currently has about 1800 entries dating back to about 2000.
So now, I need to pull a report of who (of the current staff only) DID NOT complete one of the required courses in this fiscal year. Then I can let them know the course is being offered again.
I can print a nice little pivot table of who has completed the training, and on what dates the training was offered - but I need it to tell me also who has not.
any ideas?