Dynamic drop-down list

[NyulBal]

Dear All,

I have an Excel file with 2 sheets: one for employees, and another one for trainings:

In Employee sheet I have 2 columns to choose from trainings listed in the Trainings sheet.

Each employee have to enroll to 2 trainings. I already have a drop down list under Training1 column, including all available trainings & I would like to create another drop-down under Training2 excluding the one, which has been selected as 1st training. Thus, a specific training could be selected only once per row (employee).
Could you advise a solution to create this dynamic drop-down list?

Thank you in advance.

[#2]

@NyulBal 

Attached is one way to do it. This takes advantage of the FILTER function, and that requires either a fairly new Excel or a subscription to Microsoft 365

Here's a YouTube video  that explains this use of the FILTER function more fully.