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

Sort a range of strings using VBA code? 5
value interpretation 1
Copy & Paste Conditional Formatted duplicates w/vba 0
Total columns Based on another cells value 4
Drop down list control value in vba 2
Conditional Format Formula for finding duplicates in a row 1
Unique Value Count in 3 Columns Using Search Criteria 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3

Top