Hi all,
I have an excel sheet with two sets of data (on separate sheets) which are used in two separate systems (System A and B). In the near future these two systems are going the communicate with each other via an interface. Communication is only possible if the data matches exactly. Unfortunately there where some errors made during the data migration. E.g. in system A a data point is named 1234-AA-0001 and in system B its called 1234-AA-001.
I want to identify these errors. I have already tried standard excel function as vlookup however this doesn't work because it doesn't remove the matched cells in the range.
What I want is a function that moves a row from sheet 1 (system A) to a new sheet if:
- the first 6 characters match
- and the last 3 characters match
- and the total number of characters is not equal
I have been trying to solve this for almost a week now. I hope some of you can help me.
Thank you in advance.
Best regards
Maarten
Bookmarks