Col A Col B
VEQ9DF <== Nothing should come here since it is the first occurance
VK69DD <== Nothing should come here since it is the first occurance
VK73RB <== Nothing should come here since it is the first occurance
VEA7DL <== Nothing should come here since it is the first occurance
VBR1DE
VEA7DL
LUC4DG
VBL2DG
VK69RF
VEQ9DG 1 <== This indicates the first 5 letters VEQ9D is matching to the first 5 characters on the first cell
VK69DE 2 <== This indicates the first 5 letters VK69D is matching to the first 5 characters on the second cell
VK73RE 3 <== This indicates the first 5 letters VK73R is matching to the first 5 characters on the third cell
VEA7DK 4 <== This indicates the first 5 letters VEA7D is matching to the first 5 characters on the 4th cell
VBR1LX
Bookmarks