Help on a special filter

  • Thread starter Thread starter yaunus
  • Start date Start date
Y

yaunus

I am working with a few different lists of email addresses. I need t
subtract one list for another list, and place the results in anothe
column. Who would I get ths done?

Thx, Ia
 
Ian,

You need to use a helper column. For example, if you want to subtract
the list in A1:A100 from another in B1:B200, use a formula that checks
if the value in column B appears in column A: in C1, use the formula

=ISERROR(MATCH(B1,A:A,FALSE))

Copy that formula to cells C2:C200, then sort B1:C200 based on column
C. Keep only the rows in column B where the corresponding value in
column C is TRUE.

HTH,
Bernie
MS Excel MVP
 
Same example but you could also use in column C

vlookup (b1,a1:a65000,1,false)

What this will do is to place the email address in column
c if it exists in both lists and an error message if it
does not.

Note that you may have to run these tests twice checking
the first list to the second and then the second to the
first just in case there are extras in either list.
 
Back
Top