Dynamic Drop Down

[Mark McInerney]

Hi Folks - Thanks in advance for taking the time to look at this.

I am trying to create a drop down list from a large range of data with lots of duplicates.

Is there a clever way of doing this without having to first extract a unique list using a unique filter formula?

This is what I am trying as the List data, but I keep getting this error message?

 

[Kaper]

Create a name which contains this what you entered in Source of Data Validation.

So:
Ctrl+F3
New
as name write for instance: UniqEmpName
and as Refers to: =UNIQUE(EmployeeName)
OK

and then in Source of Data Validation use: =UniqEmpName

 

[Fluff]

Assuming EmployeeName is a named range, you can simply use

=EmployeeName

for the DV as 365 automatically removes duplicates.

 

[Mark McInerney]

Thanks Folks - was not aware the duplicates were auto removed - Thanks.

 

[Fluff]

Glad we could help & thanks for the feedback.