how to extract unique numbers once from a list of repeated numbers?

Giganews Newsgroups
Subject: how to extract unique numbers once from a list of repeated numbers?
Posted by:  stuart.kw…@gmail.com
Date: 2 May 2006

Hi,

I have an Excel question.  I have a column of repeated numbers with no
pattern in terms of how many times a number shows up.

372
372
579
579
579
579
63
63
63
8
....

It always goes in this fashion: a shown number will only repeat after
itself or it won't repeat at all (e.g., 579 will only repeat after 579,
otherwise it won't repeat at all).

How do I extract the unique numbers from this column in a separate
column, such that the answer is:

372
579
63
8
....

Thank you,
Stuart

Replies