The same as "SELECT DISTINCT".

diego.gomes

New Member
Joined
Dec 2, 2005
Messages
7
Hi,

I would like to do, without VBA, the same thing the SQL command, "SELECT DISTINCT" does. I have a list with thousands of values, and I want to return only the different values.

Thankx.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Welcome to the board.

1) Select your column
2) Go to data --> filter --> advanced filter
3) choose copy to another location and fill in the destination in the copy to field
4) select "unique records only"
5) click OK
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,052
Office Version
  1. 365
Platform
  1. Windows
Try Data>Advanced Filter... and select Unique values only.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
You can utilise the Advanced Filter option and copy over unique values only - check out the Data>Filter>Advance Filter menu route and record a macro to see how to phrase the VBA.

Best regards

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,118,289
Messages
5,571,323
Members
412,382
Latest member
Langtn02
Top