Comparing two strings in excel, add value for common variables
- by overtime
I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains 100,000 randomly organized strings, that have identical values somewhere in column B.
Example:
A B C D
1 String1 …