Dear friends
I am a beginner in excel. i have different mobile companies numbers
which is starts from 4 digits as shown below:
0300, 0301, 0302, 0303, 0304, 0305, 0306, 0307, 0308, 0309
0341, 0342, 0343, 0344, 0345, 0346, 0347
0331, 0332, 0333, 0334, 0335, 0336
0321, 0322, 0323, 0324, 0325
0311, 0312, 0313, 0314, 0315
after the above 4 digit coding 7 digit number starts as below
03001234567
i have these mobile numbers data in million in one column
so i want to extract those number those are repeating same
numbers in 7 digit code which mobile companies use for
postpaid clients like below sample:
03008777119
03001000110
03001010101
03008887756
corporate numbers have some similar numbers in different
scenarios how can i extract that type special numbers from
that column.
I hope that any expert person can make this formula or module.
Attached another sample file to understand easily what i want.
Regards
Shoaib Ali
Bookmarks