I am trying to find the quickest way to complete the following task:
I am using Excel 2010 - the spreadsheet I am working on has two columns of information (names).
Column A has 200 names listed and Column B has 1500 names listed.
I am trying to find out what names listed in Column A are in Column B -- the issue is the names are not consistently entered in both columns.
So - Column A may show ABC Computer Company and column B may list the name as ABC Computer Co Inc.
Any input would be appreciated.