The same as "SELECT DISTINCT".

[diego.gomes]

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.

 

[Oaktree]

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]

Try Data>Advanced Filter... and select Unique values only.

 

[Richard Schollar]

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