If you had the first list of names in column A and the second in column C
then put this in B1 and copy down:

=COUNTIF(C:C,A1)

and this is D1 and copy down

=COUNTIF(A:A,C1)

Anywhere the result is not 0 means you have a match.


"samjwoods" wrote:

Hi,
I need to search between two sets of names to cross reference and find any
matches. The data will not have been formulated from elsewhere it will just
be lists of names (either on the same sheet or separate whichever is easier).
Is there a way to do this with Excel?
Thanks for any responses,
Sam Woods