Viewing Unique Cells

[Carl]

I have a table like so:

DD
EE
DD
CC
SS
CC

I would like to create a 2nd table that only shows me the
unique items. Sort of like this

CC
DD
EE
SS

Thank you in advance.

 

[JE McGimpsey]

Take at an Advanced Filter (Unique values only):

http://www.contextures.com/xladvfilter01.html#FilterUR