Just start learning excel and VBA and encounter a problem. Thanks in
advance for all the help. Heres the situation.

The sheet has a col A that looks like the following:

Col A
A
B
C
C
A
D
E
B
A
D

Is there a way (function or VBA) besides using advanced filter to
filter the whole column (include blank cells), pull the distinct values
and put them into another range of cells, which looks like this:

New Col
A
B
C
D
E <-- no need to sort

Once again, thanks a lot for all your input and help!! Really
appreciate it.

Rex




--
Disco
------------------------------------------------------------------------
Disco's Profile: http://www.exceltip.com/forum/member...nfo&userid=144
View this thread: http://www.exceltip.com/forum/showth...hreadid=112168

datafilteradvanced filterunique values only

"Disco" wrote in message
...
Just start learning excel and VBA and encounter a problem. Thanks in
advance for all the help. Heres the situation.

The sheet has a col A that looks like the following:

Col A
A
B
C
C
A
D
E
B
A
D

Is there a way (function or VBA) besides using advanced filter to
filter the whole column (include blank cells), pull the distinct values
and put them into another range of cells, which looks like this:

New Col
A
B
C
D
E <-- no need to sort

Once again, thanks a lot for all your input and help!! Really
appreciate it.

Rex




--
Disco
------------------------------------------------------------------------
Disco's Profile:
http://www.exceltip.com/forum/member...nfo&userid=144
View this thread:
http://www.exceltip.com/forum/showth...hreadid=112168