r121a947
New member
- Joined
- Jun 29, 2019
- Messages
- 49
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I would like to be able to find duplicate words within a single cell. The sample data are in the J column. The max number of words is around 25; 1 is the minimum. The words will be sorted alphabetically, first, to make spotting the dupes easier.
I have a very basic idea of what might work, but no clue as to how to actually implement something like this. Any and all help is greatly appreciated.
My thoughts are:
Once it works for a single cell, I can adapt it in a For loop to do all the rows. It can also be adapted to do the same chore in the L column.
Again, any and all help is greatly appreciated. Thanks.
I have a very basic idea of what might work, but no clue as to how to actually implement something like this. Any and all help is greatly appreciated.
My thoughts are:
- Count the words in the J cell.
- If the count is <2, move on to the next row.
- If 2 or >, compare each word (from 1 to n-1) with its n+1 word; if no match, move on to the next n word; if a match, paste the n word being checked in the N column, then move on to the rest of n-1 words.
Once it works for a single cell, I can adapt it in a For loop to do all the rows. It can also be adapted to do the same chore in the L column.
Again, any and all help is greatly appreciated. Thanks.
Last edited by a moderator: