Macro to Match Items in Col C

I could not agree with you more on this

What I am going to do it to get the people processing the info to use the a common ref in the narrative field

I have attached a sample of what it will look like.

I would be appreciated if you could provide me with code so where the narrative contains text with the same or similar text for eg the one may contain 191 shirts and the other 191 shirts other, then those rows re to be deleted