Hi,
I'm looking for a desperate answer regarding my problem, so if you have any suggestion please help:
I have 3 columns who look like this:
A B C
<tbody>
</tbody>
In column A i have one list with some location's name; in B list i have another list with some athore location name. My task is to highlight the difference betwen column A and B and put the result in C. I managed to do this up to a point where the column name differ; so if you can se above i have in column A 9 IND and in column B PT9 Independenta they refer to the same location but the format is different.
So my question is:
Is there a method that can automatically replace the name in column A from B, to have a perfect match? something similar to "Find and replace" function but to do it automatically, and have to overwright myself??
Please help! It's something urgent for my work; so i would very much appreciate any god ideea.
Thank you!
I'm looking for a desperate answer regarding my problem, so if you have any suggestion please help:
I have 3 columns who look like this:
A B C
PT 199 Bragareasa | PT 199 Bragareasa | PT 199 Bragareasa |
6 IND | PT 130 Grindu | |
11IND | PT Parc 5 Grindu | |
7/483 IND | PT 5 Grindu | |
378 IND | PT378 Independenta | |
9 IND | PT9 Independeta |
<tbody>
</tbody>
In column A i have one list with some location's name; in B list i have another list with some athore location name. My task is to highlight the difference betwen column A and B and put the result in C. I managed to do this up to a point where the column name differ; so if you can se above i have in column A 9 IND and in column B PT9 Independenta they refer to the same location but the format is different.
So my question is:
Is there a method that can automatically replace the name in column A from B, to have a perfect match? something similar to "Find and replace" function but to do it automatically, and have to overwright myself??
Please help! It's something urgent for my work; so i would very much appreciate any god ideea.
Thank you!