Results 1 to 13 of 13

Finding and copying rows that meet key word criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    USA
    MS-Off Ver
    Excel 2011
    Posts
    7

    Finding and copying rows that meet key word criteria

    Hi all.

    I am attempting to parse through 1000's rows of data to copy 3 specific rows that correspond to specific object (i.e., Dune Field). Each Dune field has a row that starts with "ROI", "Band 1", and "Band 2" that are irregularly spaced due to different dune field sizes. So for each of ~100+ dune fields I only need these three rows copied to another sheet.

    I followed this post:
    http://www.excelforum.com/excel-gene...ing-cells.html
    which is really close, but differ because I need: 1) to search for three key words, 2) copy all three rows and keep them in that order, and 3) the first criteria needs a wildcard for the "ROI" row as it has text after it (i.e., it is not a one word cell, but something like "ROI: EVF: Layer: Dune_Field.shp (Dune_ID=0597+369) [White] 85 points")

    Thanks much, and I have included a sample of my data to be sorted?
    MC
    Attached Files Attached Files
    Last edited by acrobaticgod; 10-29-2011 at 01:45 PM.

Thread Information

Users Browsing this Thread

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

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