+ Reply to Thread
Results 1 to 2 of 2

Find and collate rows with repeated partial text in one column

  1. #1
    Forum Contributor
    Join Date
    04-04-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    204

    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.

    T.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-04-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    204

    Re: Find and collate rows with repeated partial text in one column

    For the general benefit, my colleague got this question fully answered by Excel Expert SuZhou on this link: http://www.vbaexpress.com/forum/show...899#post387899

    I thank everyone tried to solve this question for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find cell in array that contains partial text and use column # of cell to lookup value
    By chuckyfang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2016, 10:19 AM
  2. [SOLVED] How to find repeated or most common numbers from rows?
    By sem in forum Excel General
    Replies: 20
    Last Post: 11-02-2014, 04:51 PM
  3. Replies: 1
    Last Post: 10-11-2014, 04:52 AM
  4. [SOLVED] Find the row number with a partial match to text in column A
    By zookeepertx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2014, 01:39 PM
  5. Replies: 13
    Last Post: 07-07-2010, 10:16 AM
  6. Find repeated text in column
    By sujyo1 in forum Excel General
    Replies: 2
    Last Post: 08-24-2009, 02:20 AM
  7. find the greatest value among repeated rows in a sheet
    By shijy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2005, 02:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1