In C1 enter:
=IF(COUNTIF(A:A,"=" & B1)0,B1,"")
and copy down
--
Gary''s Student


"Mike" wrote:

Hey guys, how can I match names in two different columns and kick out the
matches in a 3rd column?

For example

bill john john
mary mike mike
mike david
john sam


any ideas?

Thanks!

Mike