Forum Discussion
Subtracting specific individuals (hundreds) on one list from another
I have a list of 100,000 patients that were invited to a study. Of these, 3,000 signed up and 500 requested they not be contacted again. I have a new list of 60,000 patients , with some overlap from...
You could add a column to the second list using the MATCH function matching the ID of the current row to the ID column of the first list:
=MATCH(A2,Sheet2!$A$2:$A$3001,0)
Next filter the new column and UNCHECK the #N/A entry. THen delete all visible rows and unfilter the list.
=MATCH(A2,Sheet2!$A$2:$A$3001,0)
Next filter the new column and UNCHECK the #N/A entry. THen delete all visible rows and unfilter the list.