List of Categories/Units given in a table of data

[Daxton A.]

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

[p45cal]

Are you still on Office 2000? I hope not.
=SORT(UNIQUE(A2:A5001))
?

[Daxton A.]

Wow...thanks p45cal! Taught an old dog a new trick! And no, I am running 365 but I have slacked off a bit on learning new functions. That's why I have to use VBAexpress as a crutch!

Thanks!