Macro to identify unique values of a list

[buntalan80]

Hi,

I need a macro which scans a list of values, identifies unique values, and deletes all values except for unique values. The macro will perform and output results on the same worksheet. The macro should also not cause excel to crash if selecting the whole excel column (i.e., selecting a column by clicking on column A or all of 1,048,576 rows of column A).

Thank you.

INPUT:
AAA
GGG
BBB
FFF
CCC
EEE
DDD
ZZZ
EEE
QQQ
FFF
GGG

OUTPUT:
AAA
BBB
CCC
DDD
QQQ
ZZZ

[jeffreybrown]

Do you know Excel has a built in function for this...

http://www.contextures.com/xladvfilter01.html#FilterUR

[jindon]

try

Please Login or Register  to view this content.

[buntalan80]

Thanks so much Jindon.