I have the following:
Col A
VEQ9DF
VK69DD
VK73RB
VEA7DL
VBR1DE
VEA7DL
LUC4DG
VBL2DG
VK69RF
VEQ9DG
VK69DE
VK73RE
VEA7DK
VBR1DE
I need to compare the first 5 charcters of each cell with 5 first characters of all the cells of that column
If matched, the cell number should be displayed besides to the matched value for the second occurance

I would like to see the following output on the column B

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

Can someone help me on this one ?