Filter out duplicate data
I'm trying to write a macro that will filter out duplicate entries in a
column so that I can use the entries in that column to populate a combobox.
Here's an example of what I'm trying to do.
A
A
B
B
B
B
C
B
A
C
C
D
D
I want to filter the above data using code so that the end result is:
A
B
C
D
This doesn't seem like it should be that diffucult, but I'm having problems.
Maybe I just need a nap.
Anyways, any help provided will be much appreciated.
Thanks,
Jason
|