Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Everyone,
I have cell data, arranged in rows arranged entirely in one column, each cell contain many codes. Ideally each cell should have a unique set of codes (could be more than one). I would like to eliminate all the duplicate codes and keep only one of each code. The example cells are as follows; FA,FA,FS,FS,FZ FO,FA,FS,FO FO,FO,FO Does anyone have any idea as to what I might do in order to make the following happen: 1) FA,FS,FZ 2) FO,FA,FS 3) FO Any suggestions are sincerely appreciated. Thanks Mat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Duplicate UPC Codes in 1 Column | Excel Discussion (Misc queries) | |||
Delete duplicate cell | Excel Worksheet Functions | |||
Duplicate account codes that total amount | Excel Discussion (Misc queries) | |||
Delete duplicate data in a single cell | Excel Worksheet Functions | |||
How can delete the duplicate word from a string in cell in EXCEL | Excel Discussion (Misc queries) |