value interpretation
 

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

value interpretation
 

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

--
David Hager
Excel MVP

"solo_razor" wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/