remove duplicate entries

[Jeff Schnakenberg]

I'm trying to create a list of models from a column that has multiple models
with duplicate entries.
example:
column a
model b
model c
model b
model a
model a

List of models
model a
model b
model c

Thanks in advance for any help.

 

[Ken Wright]

Data / Filter / Advanced Filter:-

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