Saturday, January 14, 2012

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