Is there a "column compare" or similar function in Microsoft Excel 2007?

I am trying to organize a massive list of individual companies within an industry. I have one column of all the individual subsidiary companies (roughly 6000) and another with the "top tier" companies (typically with very similar names, numbering about 700). Is there a function that would allow me to... show more I am trying to organize a massive list of individual companies within an industry. I have one column of all the individual subsidiary companies (roughly 6000) and another with the "top tier" companies (typically with very similar names, numbering about 700). Is there a function that would allow me to match/compare these two columns by the similarity in their names?
1 answer 1