I'm combining text write ups from multiple cells into one.
I'm hoping to be able to remove ANY/ALL words that repeat, but keep a count of the total number of times they repeat:
IE
A1=apple. pear. fork. knife.
A2=Pear. fork. mouse
A3=dog. cat. goat. pear
A4=Apple. Pear(x3). Fork(x2). Knife. Mouse. Dog. Cat. Goat
Is this possible?
Note:
-the words wont repeat within the same source cell
-looking to combine capitalized and non-capitalized
-would be even better if it could identify repeated statements (separated by periods) as well,
IE
A1=apple. pear. fork. knife. Clean pears
A2=Pear. fork. mouse. paint the cat green
A3=dog. cat. goat. pear. Clean Pears. paint the cat green
A4=Apple. Pear(x3). Fork(x2). Knife. Clean Pears(x2). Mouse. Paint the cat green(x2). Dog. Cat. Goat
Bookmarks