Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie VBA Help Needed!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie VBA Help Needed!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP!! Help needed for newbie please | Excel Discussion (Misc queries) | |||
HELP!! Help needed for newbie please | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
Very very new newbie | New Users to Excel | |||
Help for a newbie? | Excel Worksheet Functions |