Forum Discussion
Solved
Check column for similar values
Hi, I have a software report and on the report it has different versions on different lines eg: Microsoft Office OneDrive 21.220.1024.0005 Microsoft Office OneDrive 26.45.308.3 Its a full Software...
For your reference.
Step 1: I add a 'Software No Version' column below.
Step 2: I replaced Value,"Bit"-->"".
<After>
Hi so to be clear, the Software has the name and version number so a duplicate is where the title is listed not the title and software version eg
Microsoft Office OneDrive 19.43.304.13
Microsoft Office OneDrive 21.220.1024.0005
Im looking for it tell me , as an example where Onedrive is listedtwice so its part of the text thats the same, thank you