I have the following data and the desired outcome, see below. I have about 100,000 entries. I will a loop with VBA that does the following:
If a company contains in column 2 either of the following PE, M&A, Debt (these are actually many more, I have a list of what to exclude), then delete all...