VBA to find duplicates in a cell

[Chefsohail]

Hi Team,

I need your expertise with a code that can highlight all cells in a row if the cell contains any duplicate statement. The duplication has to be within the cell.

Eg:

I am not sure if this is practically possible in excel. In case if it isn't at least the below alternative will help.

Alternative: A code that can highlight all cells in a row if the cell contains any duplicate words except for articles, prepositions and conjunctions. The duplication has to be within the cell.

I hope the examples above illustrates the requirement. I do not need the remarks column. Only the cell needs to be highlighted.

 

[Peter_SSs]

Duplicate to Vba to find duplicates in a cell

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.