Google Spreadsheet Post #2283
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Nov-12-2017
question by: S T 2
https://productforums.google.com/forum/#!topic/docs/vow6-BrFhqE;context-place=forum/docs
Show unique words
Is there a formula or other method that will output all of the unique words from a cell or range of cells into a new cell?
Is there a formula or other method that will output all of the unique words from a cell or range of cells into a new cell?
For example:
Input cells:
I like dogs
Input cells:
I like dogs
I like cats
Cats and dogs are good pets
Output cell:
I like dogs cats and are good pets
I like dogs cats and are good pets
No comments:
Post a Comment