Search : in
By :

Matching names in two columns of excel

Last answer on Jul 21, 2009 12:32:58 pm BST Ked, on Jul 21, 2009 7:46:37 am BST 
 Report this message to moderators

Hello,

Hi I have a huge list of names in excel sheet1. In the second sheet i have the same list but with differences in spelling. I need to match them to the closest possible match possibly phonetically. Any suggestions please

Thanks is advance

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Matching names in two columns of excel » in :
Excel - Extract identical cells of 2 columns ShowExcel - Extract identical cells of 2 columns Issue Solution Note Issue Hello, Got a list of words in column A Got a list of words in column B I am looking for a formula that will produce in column C a list of the words that...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
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 ......

1

 Trowa, on Jul 21, 2009 12:32:58 pm BST
  • +1

Hi Ked,

Can you give examples, cause I don't understand how a name can be spelled differently (you mean typos?).

Best regards,
Trowa

Reply to Trowa