Script to Search for a specific String then return cell values above that String-3

OK, Last one for today...I think

In the sample data you will see the string, "<Note>Record status set to 'Positive Match'</Note>" 3 times. For each of those three occurances I want to the "RecordID" above it to be shown. As you can see in the data, sometimes the string will be directly below the RecordID, sometimes 2 below and so on. I would like the result to replace the data starting in A1.

So for the Sample data, the results would be (Starting in A1):


<Entity RecordID="28579337">
<Entity RecordID="28579338">
<Entity RecordID="28582758">

Tried and tested code

Please Login or Register  to view this content.

Note: This currently copies all required into a sheet called "sheet2"