Compare two lists

D

Dave

Could anyone help me with this please?

If I have two lists of names in columns, can I get Excel
to report or highlight those items that are present in
one list but not the other?

e.g. List one is
Ann
Anna
Barney
Charles
Dave
and list two is
Ann
Anna
Charles
Craig
Dave
and I need to know that Barney is only in list one, and
that Craig is only in list two. In reality the list is a
few hundred people!

Thanks
 
Top