Hello to all gurus here..
I am quite new to macros and vba and cracking my head to solve this problem but I don't know whether it is possible.
The code suppose to get the first number and match to the rest of the numbers according to the conditions stated below and copy the matching numbers in column B.
Example:
Column A Column B
1234 1234
2456 4312
4312 1234
5826 1294
1294 1234
4326 4326
The above is exactly what I wanted. It means the code get the first number from Column A and find matching numbers in column A and then copy both in Column B. Then it goes to second number in Column A and do the same again until the end. However the matching condition is as follows:
a) the exact number ie 1234
b) all the permutation ie 1432, 1324, 2314 etc..
c) 123?, 12?4, 1?34, ?234 (ie 1254, 9234, 1238 etc)
d) backward - 432?, 43?1, 4?21, ?321 (ie 4329, 8321, 4921 etc)
Thank you..