Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keep duplicated numbers, eliminate single occurances
String of numbers....
First, i would need to conver data to numbers as some of them are formatted as =("#### "). And I assume that some may have leading/ trailing spaces since the data is uploaded. Second, i need to keep any numbers that have been duplicated anywhere in the string and DELETE the ones that appear only once. String of data starts with C4 and the end of the list/string varies. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
keep duplicated numbers, eliminate single occurances
On Jul 15, 4:08*pm, "J.W. Aldridge"
wrote: String of numbers.... First, i would need to conver data to numbers as some of them are formatted as =("#### "). And I assume that some may have leading/ trailing spaces since the data is uploaded. Second, i need to keep any numbers that have been duplicated anywhere in the string and DELETE the ones that appear only once. String of data starts with C4 and the end of the list/string varies. "If desired, send your file to dguillett @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete single occurances in a string | Excel Programming | |||
Finding Missing and duplicated Numbers | Excel Worksheet Functions | |||
Create list of duplicated numbers | Excel Programming | |||
Single Excel function to sort a list and eliminate dupes | Excel Worksheet Functions |