Excel vba array

[bymmb]

Hi Dears,

I wanna do this process without column adding and formula. Only macro i need. Could you please help me about it?

Thank you in advance.
A column data
5555555555
555555
5555555
4444
444
444444444
333333
3333
33333333
B column formula
left(A1,3)
C column formula
lenght(A1)
D column formula
{=IF(MAX(IF(B1:B1000=B1,C1:C1000))=C1,"x","")}

 

[Fluff]

Please explain in English (not formulae) what you are trying to do & also post examples of the desired output

 

[bymmb]

I think it's clear enough. Should I add an excel file?

 

[bymmb]

https://files.fm/u/zba8ne3m

This is my sample file.

 

[Fluff]

I think it's clear enough.

I don't.
If you are not willing to explain what you want & show expected results, then I cannot help.