JoannDavies
MIS
I have 2 columns in Excel. Column A is a list of companies in a not so clean format:
FordMCo
MaybeIBM maybe not
4m of NH
Smiths
etc
Column B is a list of companies nicely clean and neat:
Ford
IBM
XYZ
4M
etc
Is there some code I can run to identify which companies in column A might match something in Column B? I don't want to do any replacing or changing - just need to end up knowing which ones might need some cleanup.
Grateful for any help at all!
Joann
FordMCo
MaybeIBM maybe not
4m of NH
Smiths
etc
Column B is a list of companies nicely clean and neat:
Ford
IBM
XYZ
4M
etc
Is there some code I can run to identify which companies in column A might match something in Column B? I don't want to do any replacing or changing - just need to end up knowing which ones might need some cleanup.
Grateful for any help at all!
Joann