Hi all,
I require a help and advice on excel training matrix. As English is not my native language I might not be able to explain fully but please try to understand.
I attached the file (TEMPLATE 1) for your review. Currently, all employees in rows and training, completed date, & employee ID numbers are listed in columns next to each other.
I want to accomplish:
A
1. Employees in row (without duplication) + 2. All trainings in column + 3. completed dates to match each individual and by training completed (not all employees completed same training and different completion date!!! )
B
Possible to color counting on this?
I have tried to accomplish above with pivot tables, and filters but it doesn't work as I desired.
To give you a better understanding, I have attached a sample template report (TEMPLATE 2) - I want to TEMPLATE 1 to look similar to this, if possible.
I am sure there must be a way/method to do this. Otherwise it will take hours and lots of work to manually input this .
Hope some will be able to help and advise. Much appreciated and thanks in advance
Bookmarks