extracting unique values with a formula or with vba

S

solo_razor

hello,

does somebody know how to find unique records in a column with a
formula or with vba code.
Example:
row d:
erik
paul
john
john
erik
paul
Richard
Richard
Amanda
John
john
erik
Amanda

Now the output schould be:
erik
paul
john
richard
amanda


Regards,
Niek
 
T

Trevor Shuttleworth

Niek

use Data | Filter | Advanced Filter | Copy to another range + unique
records. Select a destination range. No VBA necessary.

Regards

Trevor
 

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

value interpretation 1
VBA, copy unique values 2
Need help with a formula 2
Finding Unique Values from Multiple Columns 1
Extracting unique entries and assigning it to a named range 3
Hiding/showing a table with VBA 2
Count Unique with condition 7
Copy each data record of a name list and place it under the onecopied 2

Top