Remove rows in excel if not in list [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I have an excel spreadsheet with chart number and data, many chartnumbers are there multiple times (which is correct). 36K rows. I want to remove patients who aren't in another list (a spreadsheet of those patients included in my study, a list of some 400 patients, one record for each person).

How do I remove the rows from the first file, which aren't in the second list. Or vice versa, select those rows that are in the second list.

Thanks,
Neil

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello
use countif function at one empty column in the 36K list to find whether it is appeared in the 400 Nos list
then filter for 0 and delete all visible rows or copy to another sheet