list with multiple repeated data

Hi, i have a column with a list of numers and letters, unsorted. the
data in this column can be repeated, it goes like this

Col1
054T
034K
056L
045L
045N
054T
076H
034K
045L

I Need a way that this codes are copied into another column (col2) but
only once. if the code is 2 or more times in col1 it should be only
once in col2. is there a formula that allows me to do this on the fly
wothout recording any macro? the result shoul look like this:

Col2
054T
034K
056L
045L
045N
076H

all the codes are in col1, but they appear only once in Col2

Sorry to bother.

Thanks for all

Arturo

Data|Filter|Advanced filter
Check unique records only.

Debra Dalgleish explains it in more detail:
http://www.contextures.com/xladvfilter01.html#FilterUR

ArturoCohen wrote:
>
> Hi, i have a column with a list of numers and letters, unsorted. the
> data in this column can be repeated, it goes like this
>
> Col1
> 054T
> 034K
> 056L
> 045L
> 045N
> 054T
> 076H
> 034K
> 045L
>
> I Need a way that this codes are copied into another column (col2) but
> only once. if the code is 2 or more times in col1 it should be only
> once in col2. is there a formula that allows me to do this on the fly
> wothout recording any macro? the result shoul look like this:
>
> Col2
> 054T
> 034K
> 056L
> 045L
> 045N
> 076H
>
> all the codes are in col1, but they appear only once in Col2
>
> Sorry to bother.
>
> Thanks for all
>
> Arturo

--

Dave Peterson