First an observation (and I also saw this on a previous iteration of your workbook): The formulas in C2:I2 are not being copied down to subsequent rows correctly. One example: in cell C3 towards the end of the formula there is a reference to ROW(A2), but in the next row, cell C4 references ROW(A4) - it should be ROW(A3). There's a number of similar problems. I'm not sure what you are doing to cause this but it is easily repaired: First, clear all filters then select C2:I2 and copy down as many rows as you need.

That doesn't solve your issue which I think is that you don't want to see "intensive" or "intensive supporting" (and maybe others) appearing in the "names to be removed column. One thought - would it be possible to filter out these values right at the data source - before they are imported to Excel? Are there other entries to be filtered, if so how do I distinguish then from real names?

While you contemplate the above, let me think if there's anything I can do formula-wise.