Function to "unique" a column's data

[Hall]

I have a column with many non-unique values. (eg
A,A,A,B,B,C,C,C,C,D,E,E,E,etc)

Is there a function I can put in another cell that can list them uniquely?
(A,B,C,D,E,etc)

 

[Tom Ogilvy]

You could combine several functions together to extract that information.

If you only need the list once and the values in the column will not change,
then you can select those columns and do

Data=>Filter=>Advanced filter

The selected cells should be shown an the source data. Select copy to
another location, then click in the box and click in the location for the
output. Click the Unique checkbox in the lower left corner. Leave criteria
blank and click OK.

 

[Hall]

Its not one time.

Can you suggest which functions to combine? I'm new to this.

Thx!