searching text values in two columns

[destrolennox]

Hello,

I have 2 columns in a spreadsheet containing names of people. Abou
75% of the names in column B are also located in column A. I want t
see which names are located in both columns. I tried to create
formula in column C using the lookup function. However, it runs int
problems when looking for names such as Smith and Smithfield. Is ther
a better search formula to use in my case? Thanks for all the help.

-Brenda

 

[David McRitchie]

see duplicates on
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm#duplicates

This question was answered in the actual newsgroup not by
usurpers of newsgroups that mess up Google web searches.