Need to remove data partly

Hello everyone,


Have an issue with data removal.
Basically, I have a file with 9953 supplier names and another 4426 names underneath (they are divided by the black line in the attached file).
What I need to do is to remove all the suppliers from the first 9953 that appear underneath, whereas the ones that are not under the black line, should stay in the file.
Thank you very much in advance!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

This in D2 copied down as far as the black line:

=ISNA((VLOOKUP(B2,$B$9956:$B$14381,1,0)))

Then sort the list on this column and remove the ones you no longer need.

No problem! Glad to have helped.