Vba count continuous names in a range

Hello I need your help.

I have a sheet with 12 columns B:M. In every col. is written names from B2:M (rows.count). Some names may be repeated. What i want is a macro that will give me the names that continuous repeated in 6 or more columns and also how many times (6, 7 etc)


Please for you help!!

Hello any help please?

This VBA code lists names that occur in 6 or more columns in Range("B:M").
It also gives the number of columns, if 6 or more, in which each name occurs.
I think this is what you ask for, but ?

Please Login or Register  to view this content.

Thanks Trebor76 & Kalak, for your replies

Also the 2 codes give me the answer that I want.
I'm fully satisfied.

Thanks 100%

Ok, i was quick to say 100%

Please for your help. Also could we add to count how many different names they resulted.

For example 1 or 4 or etc.
Could we make any modification??
Please???

It's not at all clear to me where you're at.

Try generating some test data, say by the code below and, if this is more or less the structure of your own dataset, list what sort of output you'd like to see.

If your data structure is different from this, please post an example.

I note that, on the type of dataset generated by the code below, the two codes answering your opening post, both of which you professed to be happy with, give different results. (????)

Please Login or Register  to view this content.

Ok Kalak, let me explain.
With your code in the end, when it find's a names with 6 or more times repeated, a msgbox come up with the name or names and the with the number of col. What I want is after the last name to provide a number that it will be the count of names that find to be repeated 6 or more times.

Let's say that find 5 names. After the last name: Total 5.

Now I think it is more clear???

like this then? (modifications, apart from spacing changes, in red)

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

but is this what's wanted?
it counts all values (if count >=6) in the relevant used range whether in different columns or not.

Thanks kalak and Trebor 76 for ror your replies.
But Trebor 76 in the code when it finds two names between them it place a number and in total provide 3 rather than 2.
Also the same with the first code o Kalak. But with the second it is working very well!!!

Maybe something for the previous, you could see it

Thanks!!

It's not obvious to me if you're looking for further feedback.

The two codes I posted will generally, although not always, do different things, produce different outputs, because they're addressing two different problems. That's because your real problem was never clearly stated in the first place so I had to guess.

If you'd like anything further, please post an example, preferably an attached worksheet, showing clearly the structure of your input and the output you'd like to see.