Hi,
I have two columns of data. The first column is a set of data entered incorrectly by users. The second column in a dataset that is correct, and is a smaller dataset.
I want to compare column 1 to the correct dataset, and in another column, enter the correct name.
For example,
<!-- ######### Start Created Html Code To Copy ########## -->
<!-- ######### End Created Html Code To Copy ########## -->
Please can you give me a formula or macro that looks at the strings in the cell, and finds a link, and picks up the most relevant/correct data.
Thank you
I have two columns of data. The first column is a set of data entered incorrectly by users. The second column in a dataset that is correct, and is a smaller dataset.
I want to compare column 1 to the correct dataset, and in another column, enter the correct name.
For example,
<!-- ######### Start Created Html Code To Copy ########## -->
| Excel Workbook | |||||
|---|---|---|---|---|---|
| C | D | E | |||
| 1 | Incorrect Data | Correct Data | Final result | ||
| 2 | CANEBA GERARD | CANEBA Gerard,US | CANEBA Gerard,US | ||
| 3 | SCF TECHNOLOGIES AS | BRUMMERSTEDT IVERSEN STEEN | FELSVANG KARSTEN | LARSEN TOMMY | LUETHJE VIGGO | SCF TECHNOLOGIES A/S,DK | SCF TECHNOLOGIES A/S,DK | ||
| 4 | SAUDI ARABIAN OIL CO | SAUDI ARABIAN OIL COMPANY | SAUDI ARABIAN OIL COMPANY | ||
| 5 | SHELL OIL CO | Shell Oil Company | Shell Oil Company | ||
Sheet1 | |||||
<!-- ######### End Created Html Code To Copy ########## -->
Please can you give me a formula or macro that looks at the strings in the cell, and finds a link, and picks up the most relevant/correct data.
Thank you
