I need to set data validation from a list and I need the list of values to dynamically display the unique values from a list in a range. So if the list had:
111
222
222
333
333
333
444
444

I need the dropdown to propose:
111
222
333
444

I know how to do a dynamic range name, it is the unique value bit that I cannot do. I would prefer a single formula that can be entered in the data validation dialog as opposed to creating multiple ranges and then pointing the list to the last one.

TIA,
Ken