I have a list of employees on sheet2 (1 column of names) and days of the week on sheet1 (multiple columns each is a day of the week with different jobsites down the rows). Each employee is assigned to one jobsite each day. I would like the list to reduce based on whom is selected in the day column so I can tell who is still unassigned. I have managed to get this to work for one column but I cannot figure out how to get my dynamic list to reset and see what names have been used in the newly selected column. Thanks for any help you can offer.