comparing 2 sheets

[rodchar]

hey all,

i have 2 sheets that contain a column of names on both

s1
john
amy

s2
john
chris

is there a way to find out, for example, names in s1 that don't exist in s2?

thanks,
rodchar

 

[Sean Timmons]

The easiest way is to use a separat column. let's assume your lists are in
column A of both, and start in cell A2 (A1 being a header)

in B2 of sheet1, enter:

=countif(sheet2!A:A,A2)

change your sheet name and column references as needed.

any with a 0 are not in the other list.

You can do boh ways to capture those one either list but not on the other.

 

[rodchar]

Thanks for the help,
rod.

The easiest way is to use a separat column. let's assume your lists are in
column A of both, and start in cell A2 (A1 being a header)

in B2 of sheet1, enter:

=countif(sheet2!A:A,A2)

change your sheet name and column references as needed.

any with a 0 are not in the other list.

You can do boh ways to capture those one either list but not on the other.