MatchEm_10 - Determines what rows are similar, if any.
Author/Solution Provider: Brad Byundt
Refer to prior post: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_25345093.html
1) Code - Included as a Module in the attached file.
2) Sample Data - Includes RSLT sheets with examples of mis-matched data.
MatchEm_10 does not seem to handle columns with duplicate content. But it might be something else.
I've taken the following precautions:
- Start in row 2
- Use =Trim(ROWCOL) to strip leading & trailing whitespace
- I've tried the longer column of data on the left, and visa-versa.
Can someone help me figure out why the matching results are incorrect? It had been working fine on other data files.