Search : in
By :

COMPARING TWO COLUMNS OF NAMES IN EXCEL

Last answer on Nov 11, 2009 9:29:53 pm GMT STEMPEKA, on Feb 18, 2009 4:19:47 pm GMT 
 Report this message to moderators

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!!!

Configuration: Mac OS X
Safari 525.27.1

Best answers for « COMPARING TWO COLUMNS OF NAMES IN EXCEL » in :
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ... for...
[Excel]Storage name and path of a spreadsheet Show[ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1)...
Comparing the contents of two folders ShowComparing the contents of two folders Under XP, it is possible to integrate a function that allows you to compare the contents of two folders. This may be useful when dealing with folders containing a lot of files and that you...
Ask your question Reply

1

 zia, on Feb 19, 2009 9:52:45 am GMT
  • +30

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)

   
Reply to zia
Ask your question Reply
They need your help