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
Bookmarks