yogi_Extract Unique Recurring Values From A Column Of Repeating and Recurring Entries

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user jacke said:
Hi,

I got column A:

red

red

red

red

green

green

yellow

blue

blue

blue

green

green

red

red

red

brown

black

black

Which formula should I use to get from that ^ something like this:

red

green

yellow

blue

green

red

brown

black

I havn't spoke english for such long time, so I cant find words to explain my issue, sorry! Hope you can lead me to solution : )

------------------------------------

following is a solution to the problem