| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to extract unique numbers once from a list of repeated numbers?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to extract unique numbers once from a list of repeated numbers?
Hi Stuart
You can use Advancedfilter http://www.contextures.com/xladvfilter01.html#FilterUR -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to extract unique numbers once from a list of repeated numbers
If this is something you have to do frequently, I would recommend Jim Cone's
fine commercial Add-in called XL Companion. It's available at ... http://www.realezsites.com/bus/primitivesoftware/ hth Vaya con Dios, Chuck, CABGx3 " wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
| find sum in list of of numbers | Excel Worksheet Functions | |||
| Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Linear Mode
