Unique values of a range

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Anyone has an idea how to select the unique values of a
range (kinda select distinct) into a vector by using
worksheet functions ONLY (no VBA, no own addin, etc.)?

Joe
 
Use Advanced Filter menu and in the dialog box that comes
up, "tick" the Unique Records only field
 
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

Unique values of a range 3
Unique/Distinct Dropdown List 10
Return the value from one range that does not exist in another 0
Count Unique Values in 1 Column based on Date Range in another Column 28
Automatically extracting unique values 5
Counting Unique Values 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Convert a 8X3 table to a vertical range of the Unique strings only 8

Back
Top