M
Mat
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
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