I have been puling my hair out trying to figure this out and have recently found this thread: How to search for random patterns within a column answering a very similar question to what I'm asking below, but this is looking for strings of 5 characters in a column of random letters and numbers.
Instead of finding characters my data set has strings of words separated by a space (e.g. I You my me your we etc) in each cell, so searching for characters alone would produce unusable results
Whilst the linked thread searches each cell to find all 5 letter character patterns, I want to find word patterns starting from 2 words and increasing indefinitely until no other matches are found
Is there a way to edit the solution from the linked thread to do this? Here's the solution from user BSALV current solution that works for 5 character patterns and formats the results how I'd need for my current problem
In brief I'm trying to:
Instead of finding characters my data set has strings of words separated by a space (e.g. I You my me your we etc) in each cell, so searching for characters alone would produce unusable results
Whilst the linked thread searches each cell to find all 5 letter character patterns, I want to find word patterns starting from 2 words and increasing indefinitely until no other matches are found
Is there a way to edit the solution from the linked thread to do this? Here's the solution from user BSALV current solution that works for 5 character patterns and formats the results how I'd need for my current problem
In brief I'm trying to:
- find word patterns, rather than 5 character patterns
- have a range beginning with groups of 2 words and increasing until no more repetitions are found
- omit patterns that do not repeat (as the current solution includes these, but my data set is too large for this to be usable)
- make it case sensitive - important as capitalisation has been used to indicate other variables to the reader
