Search for 3 digit number in a four digit number

Hi everyone,

Can anyone please create a VBA code to search a 3 digit number in many four digit numbers and count how many that are there? Let me explain more descriptively, in my worksheet, there are many 4 digit numbers, and I want to know how much times a certain 3 digit number appeared in my worksheet. In 1234, there is, 123,124,134,234, right? Okay, so if I want to search for like a 234 in my worksheet, the computer should recognize 1234, or 4321 or 4123 or any number that have 234(in any order like 432,342, and so on) and count how many are there. Please help. Here is one small part of my worksheet.

Hi Jbeaucaire,

I can't seem to make it work, can you please apply it to the attached file in post 1, and attached it for me, please? Thank you.

Don't understand why "4054" in Yellow counts for "434".

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by Jerry HKA

Hi everyone,

Can anyone please create a VBA code to search a 3 digit number in many four digit numbers and count how many that are there? Let me explain more descriptively, in my worksheet, there are many 4 digit numbers, and I want to know how much times a certain 3 digit number appeared in my worksheet. In 1234, there is, 123,124,134,234, right? Okay, so if I want to search for like a 234 in my worksheet, the computer should recognize 1234, or 4321 or 4123 or any number that have 234(in any order like 432,342, and so on) and count how many are there. Please help. Here is one small part of my worksheet.

Please Login or Register  to view this content.

Sorry, it was my mistake that the 4504 was highlighted. It shouldn't be.

Originally Posted by Jerry HKA

Sorry, it was my mistake that the 4504 was highlighted. It shouldn't be.

Is it working or not?

http://www.giaiphapexcel.com/forum/s...7919;-số

To Sa DQ,
I can't seem to make it work. Can you apply it to the attached in post 1. Thank you.

To Jindon,
Why is it only searching for 434 and 663, if it is not the result you got, can you approach the code and make it to search the worksheet, and arrange the numbers from most appeared, to least appeared. Thank you.

To Jbeaucaire,
Can you make the code help me search for many numbers at once, that will help me save time, pleas do try. Thank you

Originally Posted by Jerry HKA

To Jindon,
Why is it only searching for 434 and 663, if it is not the result you got, can you approach the code and make it to search the worksheet, and arrange the numbers from most appeared, to least appeared. Thank you.

I don't understand what you are talking about.
I wrote the code according to your sample file.

What is your question then???

I'm terribly sorry, Jindon,

Your code is only searching for 434 and 663, but I don't only want to find those numbers, there are million of numbers wanted from me. But I only gave the two numbers as an example of the desired result. Please disregards the other written in the post for you.

Or is it my fault of not knowing how to use your code properly, if so, please educate me of what to do.

Originally Posted by Jerry HKA

I'm terribly sorry, Jindon,

Your code is only searching for 434 and 663, but I don't only want to find those numbers, there are million of numbers wanted from me. But I only gave the two numbers as an example of the desired result. Please disregards the other written in the post for you.

Where are they?

Okay, I tanhk you Jindon for helping me out here. I will be needing your help in the future. Thank you, Jbeaucaire, for your help. I really respect you. Thank you for all.