Menu
Ask a question Report

COMPARING TWO COLUMNS OF NAMES IN EXCEL [Solved/Closed]

STEMPEKA - Feb 18, 2009 at 11:19 AM - Latest reply:  JeffS79
- Apr 16, 2013 at 06:33 PM
Excel Ask a question Report
Hello,

I have one excel sheet. column A has a list of names formated as follows:

Last name, First name

column B has a much longer list o names in the same format.

Some of the names in column A exist in column B.

I am looking for a formula that will produce in column C the names that appear on both lists.

Thanks for your help!!!
See more 

8 replies

Best answer
Report Respond to zia
zia - Feb 19, 2009 at 04:52 AM
223
Thank you
user vlookup formula if you have same name in second column
=vlookup(select any one name in column A prefer first name , then select full range of column B then ,1,FALSE)

Thank you, zia 223

Something to say? Add comment

CCM has helped 1814 users this month

Report Respond to Tamizh
Tamizh - Aug 30, 2010 at 05:39 AM
74
Thank you
Hi You can have a true or false formula as
=A2=B2. Then if same cell has the same data you will result it with True. If not the same will be False.
Report
tarun - Jan 17, 2013 at 07:39 AM
its working only for MS office 2007
not in 2010
Report
JeffS79 - Apr 16, 2013 at 06:33 PM
This worked great as a very fast audit of 2 rows of text. Just type in the formula and filter by "false" to find the discrepancies. Amazing tip!
Report Respond to Ravindra
Ravindra - May 26, 2010 at 12:01 PM
59
Thank you
I have an Answer :

It is possible that I can give you the formula you will get the details of the name which you have in column B

Ex : =vlookup(select column b,select the range the same you have in column A,1,0) hit the Enter and drag the formula till the end.
Report
igor - Jul 1, 2010 at 01:40 PM
Dragging it was the key! Thank you
Report
yaykarin - Aug 17, 2010 at 05:35 PM
Yes! I have tried SO many different "solutions" this finally did it. I had a long column A, a short column B and was able to remove any appearing in A that also appeared in B. So simple and yet so complicated. Thanks!
Report Respond to xlcomparator
xlcomparator 16 Posts Thursday September 17, 2009Registration date August 9, 2017 Last seen - Dec 14, 2009 at 02:14 PM
18
Thank you
Hi STEMPEKA,
I see that this thread status is "not resolved".
You will find here an other way to solve your problem without using macro or formula :
http://ccm.net/faq/5278-how-to-compare-two-workbooks-worksheets
I hope this helps
Marc
Ask a question
Featured