Hi,
I am a new user to this site and also new user of excel. I need help to search individual cells that contains multiple strings of data, and then delete the duplicated data contained in that cell. Is this possible?
Many Thanks
Ben
This below shows what data would be contained in 1 cell.
CN2233, CN2233, CN2134, CN2266, CN2233, CN2136, CN2266
And this would ideally be the result after the process/formula/macro
CN2233, CN2134, CN2266, CN2136
so the duplicated data would be deleted.
Is it essential that you keep this data in the one cell? Is it possible to parse the data into multiple cells? of course everything is possible, but let's first ensure that what you are asking for is what you actually need.
try..
Please Login or Register to view this content.
this is better it gets ride of the trailing ,
Please Login or Register to view this content.
Last edited by pike; 01-22-2010 at 10:31 PM. Reason: add clearcontents
Ben Lewis,
See the attached workbook "Array - Deleting duplicate data from a cell - Ben Lewis - SDGD12.xlsm" with macro "RemoveStringDups".
Detach the workbook and run the "RemoveStringDups" macro.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
hi all,
Here's another variant which is similar to Pike's & Stanley's - I tried to post last night but had connection issues.
It works on the current selection (no error checking for selection type though) & uses Join after working through the elements of the array. I have tried to make it work for non-contiguous ranges as well by looping through the selected areas. It is based on some of Jindon's code that I picked up some time ago.
Potentially, it (or the others) could be made faster by creating in memory arrays based on the range, processing the strings, & then writing them back to the sheet in one hit (instead of one cell at a time). This would become more significant as the selection size increases.
Please Login or Register to view this content.
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
hi Ben Lewis
or with the more adaptable dictionary
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks