Subtracting one list from another list

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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
 
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
 
Thanks Duke.


Duke Carey said:
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
Click to expand...
 
Back
Top