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

Hello,

I am trying to figure out a way to comb through data and look for a specific string and show only what is in the cell above that string. The string will appear multiple times so the script needs to repeat to find every occurance.

With the sample data attached, below would be the result:

<Entity RecordID="28469234">
<Entity RecordID="28469389">
<Entity RecordID="28469687">

You didn't specify how you wanted the output, so this just displays the results in a message box. Could easily be modified to put the results in another column, or sheet, or whatever.

Please Login or Register  to view this content.

Thanks for the quick response!

Would it be possible to have the results replace the data currenlty in the sheet...If not I can just make an additional sheet to copy and paste the results?

Would it be possible to have the results replace the data currently in the sheet

Please Login or Register  to view this content.

Another - uses msgbox

Please Login or Register  to view this content.

Adding:

Please Login or Register  to view this content.

Will place the results in K1

These have both worked great! Thank you both for you quick assistance!