Subtracting one list from another list
If this were in a database, you'd do a simple 'NOT IN' query. In Excel
you'll have to use a formula, say in col C, to determine if the col B value
is in col A, then filter on the values in col C
if your col A values run from row 1 to 5000, then in C1 use
=IF(ISERROR(MATCH(B1,$A$1:$A$5000,0)),B1,"")
Copy it down to the end of col B data, then filter for <"", copy the
results and paste as values in a new sheet
"Brian" wrote:
Howdy All,
Here is what I have.
Column A is a list of several thousand record numbers, Column B is a list of
several thousand record numbers.
What I want to do.
I want to remove all the numbers which exist in Column A from the list of
numbers in Column B.
Any ideas on how this is accomplished are greatly appreciated.
Thank you,
Brian
|