Shankar Nar
New Member
- Joined
- Jan 23, 2019
- Messages
- 1
Hi Experts,
I was not able to find a thread similar, so starting this thread.
I am a novice in excel and I am trying to compare the softwares of an application with the master data list.
My questions are as below.
1. I have to compare 2 strings in this scenerio (e.g COL A - microsoft visual c++ redistributable 2015 x64
Col - B - visual c++ redistributable 2015 x64)
2. I have to extract the Software name, year and version from Col 1.
Below is the data.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I was not able to find a thread similar, so starting this thread.
I am a novice in excel and I am trying to compare the softwares of an application with the master data list.
My questions are as below.
1. I have to compare 2 strings in this scenerio (e.g COL A - microsoft visual c++ redistributable 2015 x64
Col - B - visual c++ redistributable 2015 x64)
2. I have to extract the Software name, year and version from Col 1.
Below is the data.
| Software List - MasterData | Software List - Application Data | Version | Year |
| microsoft visual c++ 2013 | visual c++ redistributable 2015 x64 | ||
| microsoft visual c++ 2013 x86 | visual c++ 2013 | ||
| microsoft visual c++ 2015 x86 | r for windows 3.1.1 | ||
| ibm sterling connect:direct 4.2 | activeperl-5.24.1.2402-mswin32-x86-64int-401627 | ||
| ibm urbancode deploy agent 6.2 | hp sa agent | ||
| microsoft visual c++ redistributable 2015 x64 | r for windows 3.3.2 | ||
| microsoft visual c++ redistributable 2015 x86 | syslog-ng agent for windows (remove only) |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
