Help needed deleting specific rows.

Hello there,

We are working on a research project pertaining to the Covid-19 virus. We need to curate a long list of anti-viral agents down to a manageable list. We have removed a few antiviral agents and would like to remove some more. List 1 (titled Worksheet 1 in the attached file) is what I would like to retain, it contains about 23,000 different anti-viral agents. The rest of the anti-viral agents have to be deleted from the bigger list ( list 2 titled Worksheet 2 in the attached file) containing roughly 30,000 anti-viral agents. Both of these lists have been entered in 2 different worksheets. List 2 contains the anti-viral agents from list 1 but it contains 7,000 additional anti-viral agents that I wont be needing. Hope the question is clear. There are around 30,000 rows so deleting the rows manually is not feasible. Is there any add-in or built-in Microsoft Excel feature that will let me delete the rows automatically.

Thank you for your time and consideration.

Select the top row of the data and select Data=>Filter, drop-down arrows will appear on the top row.

Click the arrow and select what you want to filter for. Lots of options and custom filters as well

Worth the practise.


dataFilter.jpg

Hi, if you can attached a file and stated what you desire to get for your final reports, and I think this can be done using Power Query.

This will undoubtedly require VBA, so I've taken the liberty of moving your thread to the VBA section.

Hi,

Bring in Worksheet1 and Worksheet2 to Power Query Editor, Merge both of them as New, filter those not in Worksheet1, load to excel in Final worksheet

If this is what you want and a simple way

Try:

Please Login or Register  to view this content.