value interpretation

[solo_razor]

hello,

I want to look for values in a column and then copy those values in
another sheet.
example
if column d has 5 different value's i want to isolate these values and
copy those into another sheet.

d
paul
paul
john
paul
erik
jacob
jacob
paul
erik
nick
nick

now in the sheet2 the output should be
paul
john
erik
jacob
nick

Regards,
Niek

 

[David Hager]

Use Data, Advanced Filter with the Unique Records only option.