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

S

stuart.kwok

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count quantity of repeated items in a column 4
How to use pivot table to count repeats of unique fields 4
How do I consoldiate a List of numbers to show each number once ? 5
how to delete repeated numbers in a column, make it apears once 1
Extract a number from a variable text string 4
Extract select group of numbers 3
Extracting from a List 1
Extracting numbers from alphanumeric string 1

Top