russelljones
New Member
- Joined
- Jan 31, 2017
- Messages
- 7
Morning all!!
I have searched and tried and error'd on the below- any help you can provide would be greatly appreciated!!
I have a table containing a list of employees and dates training they have completed a follows:
<colgroup><col><col><col><col span="5"></colgroup><tbody>
</tbody>
From this, I have created a new sheet, and want to run some kind of filter/lookup whereby I can select the relevant training from a drop down list, and it return a list of employees who have that training and the date they completed it, as follows:
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Thank you all in advance!
Russ
I have searched and tried and error'd on the below- any help you can provide would be greatly appreciated!!
I have a table containing a list of employees and dates training they have completed a follows:
A | B | C | D | E | F | G | |
1 | H&S | ICT | Security | Data Compliance | Other training | More Training | |
2 | John Smith | 01/05/2018 | 10/09/2019 | ||||
3 | Joe Bloggs | 05/05/2018 | 10/09/2018 | 25/01/2017 | 01/01/2019 | ||
4 | Richard Smith | 02/12/2017 | 05/08/2017 | 25/09/2017 | |||
5 | Amanda Jones | 04/08/2019 | Jan-19 | ||||
6 | Racheal Smith | 04/08/2019 | 09/03/2017 |
<colgroup><col><col><col><col span="5"></colgroup><tbody>
</tbody>
From this, I have created a new sheet, and want to run some kind of filter/lookup whereby I can select the relevant training from a drop down list, and it return a list of employees who have that training and the date they completed it, as follows:
A | B | C | D | |
1 | Select Training Type: | H&S | ||
2 | ||||
3 | John Smith | 01/05/2018 | ||
4 | Joe Bloggs | 05/05/2018 | ||
5 | Richard Smith | 02/12/2017 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Thank you all in advance!
Russ