Extract same number and name in a cell

Hi all,

I have an issue when extracting same phone number and client name in a cell

I want to remove the same phone number and client name that don't have phone number

The result
- Because ABCD is a client name but it doesn't have phone number, I remove the name
- 0933710850 XYZW is the same information , so 0933710850 XYZW is removed
- The first letter of every phone number (it can be 10 to 13 digits) should equal "0". If the two first letter is "84", it should be replaced by 0.

For example 0933710850 is ok, 84933710850, "84" will be remove and replace by 0

Actually, I write the code but it has error 1004 and I can not fix it

Please Login or Register  to view this content.

Thanks for reading and helping

Is [B3] in this line

Please Login or Register  to view this content.

as cell on sheet1? If so, I think it should read

Please Login or Register  to view this content.

In the same line, should rear be rearr?

I'm not to familiar with arrays in code, but should

Please Login or Register  to view this content.

be

Please Login or Register  to view this content.

or something of that format?

Edit* Looking back at your code, I think I am incorrect.

Someone else will have to step in and help out with this. I'm not familiar with arrays and such within code to know what to do here.

Thanks Jindon,
Your code is so wonderful, it is so fast.
Sorry for my mistyping on the latest file. I just uploaded new file. The code just remove same numbers if a cell has a number and name. I want remove all the same number and just keep the only one

Ex there are twothe same phone number "06503913922", the second number should be removed and keep the one "06503913922"
test 2.png