value interpretation

  • Thread starter Thread starter solo_razor
  • Start date Start date
S

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
 
Use Data, Advanced Filter with the Unique Records only option.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extracting unique values with a formula or with vba 1
copy several rows 7
Find a value in a sheet and replace it with another value if it matches 8
Macro to match 2 column values in different sheets 1
Sheet to sheet code Type Mismatch 6
modified pivot table using a macro 2
Transfer array element offset value to a matched value 3
delete row off 5 worksheets containing specific value 8

Back
Top