Reducing data validtion list in multiple columns to not allow duplicates

**eksweeper16** · 04-06-2015, 03:12 PM

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.

**simarui** · 04-06-2015, 03:18 PM

can you upload a sample of your workbook demonstrating the issue your having and your desired result?

**eksweeper16** · 04-06-2015, 03:32 PM

NAME RANGE TEST1.xlsxI would like to get all columns on Sheet1 to operate like column I on Sheet2. I hope this is what you are looking for I am new to the forum.

Thanks,

**simarui** · 04-06-2015, 04:33 PM

i accomplished your desired result using two helper worksheets, Sheet3 and Sheet4 in which I basically replicated your formulas from Sheet2 (Search() isn't actually what you want...)

i spent a while trying to avoid the helper sheets but never came up with anything... hope this is satisfactory.

**eksweeper16** · 04-07-2015, 07:23 AM

That was awesome I have been working on it off and on for a week. I am fairly new to working with Excel. Thank you I never thought about the additional sheets.