I'm working on analysing one data worksheet which has over 6200 rows (no blanks) within 7 columns (A:G).


ColD has the main data fields which are the focus of this question.


I need to find EVERY repeated THREE WORDS in all ColD cells, highlight them in red, and collate the entire data rows of those cells in groups separated with one blank row in another worksheet.


I have manually created the attached example, hoping it would illustrate my question properly.


I do appreciate any precious assistance with this question.


Many thanks in advance.

sample_data_example.xlsx