hello,
Could someone please assist how to extract unique values from a certain column into another column. I want to "exclude" any blanks and also have it sorted alphabetically if its all letters or sorting in ascending order if they are numbers.
I know that you can somewhat do this with "advanced filter" but I would like it done in VB in a macro.
Any assistance would be great. I have done a search but i cannot find anything specific to what i require.
here is a screen shot of what i need. Column A has the data. I want to end up with what is in Column D.
Thanks in advance.
Could someone please assist how to extract unique values from a certain column into another column. I want to "exclude" any blanks and also have it sorted alphabetically if its all letters or sorting in ascending order if they are numbers.
I know that you can somewhat do this with "advanced filter" but I would like it done in VB in a macro.
Any assistance would be great. I have done a search but i cannot find anything specific to what i require.
here is a screen shot of what i need. Column A has the data. I want to end up with what is in Column D.
Thanks in advance.
Book16.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Data | UniqueValues | ||||||
2 | bb | aa | ||||||
3 | bb | bb | ||||||
4 | cc | |||||||
5 | cc | dd | ||||||
6 | zz | ff | ||||||
7 | cc | zz | ||||||
8 | zz | |||||||
9 | ||||||||
10 | aa | |||||||
11 | ff | |||||||
12 | dd | |||||||
13 | cc | |||||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
Sheet1 |