Comparing Two Columns of Text
 

I have two columns of names and would like to see which names are in
both columns. I believe that they all will match exactly, if I can
compare them. Any help is greatly appreciated!

Thanks
Heather


--
sailortigger
------------------------------------------------------------------------
sailortigger's Profile: http://www.excelforum.com/member.php...o&userid=24499
View this thread: http://www.excelforum.com/showthread...hreadid=380955

Chip Pearson has lots of ways to work with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

sailortigger wrote:

I have two columns of names and would like to see which names are in
both columns. I believe that they all will match exactly, if I can
compare them. Any help is greatly appreciated!

Thanks
Heather

--
sailortigger
------------------------------------------------------------------------
sailortigger's Profile: http://www.excelforum.com/member.php...o&userid=24499
View this thread: http://www.excelforum.com/showthread...hreadid=380955

--

Dave Peterson

Mmm,

Do you need to keep track of multipe "Smith"s for example. i.e. is the
3rd Smith in col A a failure if there are only 2 Smiths in col B?

Gaz


--
gazornenplat
------------------------------------------------------------------------
gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494
View this thread: http://www.excelforum.com/showthread...hreadid=380955