Comparing two different sets of data with common element

[tutaref]

Hello

I get databases from two different sources. The larger one has six columns
of information including an email address.

The smaller one has the same email addresses amongst its columns, though far
fewer rows.

How can I produce a list of those people in teh larger database who are not
in the smaller one, using the email addresses.

 

[Joel]

You can use the =countif function. the countif returning 0 are tthe ones not
in the list
if the range of e-mail address in smaller 5 column database is 'sheet2!C1:C200

Assume e-mail address in larger database is in column E and the database is
in columns A-F

create in the larrger database in cell G1
=countif('sheet2'!C$1:C$200,E1)

Copy cell G1 to the rest of column G. Entries with 0 zre the cells you are
looking for.