Sorry if this questions has been asked recently. I have searched for an
answer to no avail.

I'm trying to write a macro that will search an excel spreadsheet for exact
text. Once if finds the exact text match(es)
it should then assign a value to a cell in the same row (maybe yes or no)
then it should sort the list by rows that match delete the rest.