I have a list of 5,000 categories and they are not listed in any given order. I am needing a list of different unit types. I started creating loops in vba that are nested and that seems really long. So is there a quicker way for this to be done?
Example:
=======
A
A
C
D
A
D
Result:
A
C
D