-
Find and collate rows with repeated partial text in one column
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules