Home » Forums » Open Source Learning Center » Question and Answer

Unique List

Vishesh's picture
Submitted by Vishesh on 13 February, 2010 - 03:14

Can somebody come up with a shortest possible code to get a list of unique out of a range ? Suppose you have data in Column A which contains duplicates. I want a list of uniques in column C. How is that possible with minimum of coding (but with coding only) ?

‹ VBA function to get the name of a name.... Error Connecting SQL Server 2005 using Excel VBA ›
»
Nick's picture

unique list

Submitted by Nick on 15 February, 2010 - 08:29.

how about this one liner:

    Range(Range("a1"), Cells(Rows.Count, 1).End(xlUp)).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("c1"), Unique:=True

 

Nick

 

»