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

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" wrote:

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

Thanks for the help,
rod.

"Sean Timmons" wrote:

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" wrote:

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