Ok I know something like this can be done with code like this:
Columns("X:X").AdvancedFilter Action:=xlFilterInPlace, Unique:=True

However the sisuation is slightly more complicated.
So I have a data sheet in which, lets say, column Y holds project names.
In column X there a names of persons who lead the project.

So now I wanted to make a validation in a given cell where a user can choose a project name.
What the macro then should do is filter the list on chosen project.
So far so good, but next step would be that he copies the column with names to a certain position so I then can have the macro create a validation on that list of names.

Still so far this works BUT if a name occurs multiple times I also get the name multiple times in my validation drop-down list.
And that is ofcourse something I do not want.
Hence my question to only get the unique records when he pastes the name column to the position were he should make the validation.