comparing 2 sheets
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
|