Excel Text Differences Comparison & Reporting
Budget: $30 – $250 USD
I'm seeking someone who can help with an Excel task. I have two columns of keywords in comma separated text values. I need a VBA script that will compare the values in each row of the two columns and report the differences. One cell is alpha numeric order, second cell is random order. Keywords can be a single word value, two or more words. The full keyword/keywords between commas is the value to be used for comparison. Ignore upper case, treat everything as lower case.
Key Task:
- Compare comma separated values in two columns
- Report keywords from second column D not found in first column C in a new column F
The new column should be named "F-Keys-on-D-not-on--C".
Do NOT change columns A or B.
Required Skills:
- Proficiency in Excel VBA
- Experience with comparing text values
- Detail-oriented and able to accurately identify differences in text
- Strong communication skills to ensure the project is completed according to the specifications.
Supplied: spreadsheet of 10 records showing expected results. Column G is informational for you.
Full excel table is 27,000 rows
Key Task:
- Compare comma separated values in two columns
- Report keywords from second column D not found in first column C in a new column F
The new column should be named "F-Keys-on-D-not-on--C".
Do NOT change columns A or B.
Required Skills:
- Proficiency in Excel VBA
- Experience with comparing text values
- Detail-oriented and able to accurately identify differences in text
- Strong communication skills to ensure the project is completed according to the specifications.
Supplied: spreadsheet of 10 records showing expected results. Column G is informational for you.
Full excel table is 27,000 rows