Creating a drop down menu that excludes certain values

Hello all,

I am creating a dropdown list for the rota in columns B to E based on the range L3 to L20, but I would like it to exclude the values in the leave row for the same date.

So far example, I would like Cell B2 to have a drop-down list with all of the initials from L3 - L20 excluding the initials from G2 and H2.


Rota.png

Thanks