Assuming a similar table is what you're using:

Rows Col A Col B

1 Mike Mary
2 Larry Larry
3 Pete John
4 John Stephen

You can use the following formula to show where the same name appears in
both columns, type this in cell C1 and copy-paste onto the cells below it
(C2, C3....)
=IF(A1=B2,A1,"")


"Cheimbig" wrote:

In excel, if you have Column A that has a list of names €“ in Column B you
have another list of names and in Column C you want to show any from A and B
that match €“ do you know the formula to do this?

I found one that shows me the number of matches, but I actually want to see
the actual names that match.

Suggestions? Thanks in advance
--
Carla Heimbigner