Drop Down List without Duplicates

one way is to use a pivot table somewhere to return a unique list then use that in your validation. refresh pivot table if you think new names may have been added
see attached

Re: Drop Down List without Duplicates

--------------------------------------------------------------------------------
Wherever you're sourcing the data from in the drop down table must not contain duplicates. Then you only have two choices, either remove the duplicates from the original data or copy the data to other cells, remove the duplicates and source your drop down box from the copied cells.

If you are trying to find a list from the data with no duplicates the easiest way of doing this is to select the data that you wish to evaluate, click on data > filter> advanced filter

Then check the box labeled "Unique records only" then you can choose to either filter the list in place or to create a copy of the new list somewhere else. the copied list has to be placed on the same sheet as the original, but you can move it afterwards.

Thanks martinwilson!!

I am much more inexperienced than you. How did you name a pivot table so that you can reference it in the list as =mynames and allow it to expand dynamically in size?

Thanks martinwilson!!

I am much more inexperienced than you. How did you name a pivot table so that you can reference it in the list as =mynames and allow it to expand dynamically in size?

Originally Posted by clidaka

Thanks martinwilson!!

I am much more inexperienced than you. How did you name a pivot table so that you can reference it in the list as =mynames and allow it to expand dynamically in size?

Hi, nevermind I figured out how to name. Thank you so much everyone! I have a solution!

glad to have helped