I have a column of values say :
I am happy and sad
I am extremely happy
I am sad
I am very sad
I am very very sad
Excel have to automatically identify and delete the words that have been repeated. In this case, after running macro I should be left with only :
because all other words are repetitive. i don't have a list of words, so Excel should automatically gives us only Unique words which haven't been used more than once.
Does this macro is practicable?