Button to show the TRI 4N WK

You didn't attach a workbook.

sorry !

upload now

If BF is the source, why do you call this "TRI", meaning three?

Martin

If BF is the source, why do you call this "TRI", meaning three?

Yes
because are three digit repeat

What should the result be for this week?

Martin

this is the  result for the week 13w20112



but not repeat is going so no data will be pickup

we need have the 2 or more tri repeat
as  show in week 36W2013


here the result



but just the count of 2 or more are post in column CJ and the count column CK

Try this.
29085662.xlsm

Martin Great JOb  !!

have this situacion

this the count for  31W2013


215   and   413 don't showup

I thought you were looking for "215" rather than the 215 in 2615 (for example).

If the 4-digit number were 5162, does that contain "215"?

MArtin

The source column BF
is and have to be always in the order

2,4,6,8,0  then   1 ,3 ,5,7,9


If i understasnd your question

that will be always the order

not other order can be for column BF

If the 4-digit number were 5162, does that contain "215"

yes but the order is the law

According to the "law" does 2615 contain both 215 and 615?

Martin



more easy

Please attach a copy of the workbook that those results came from.

4n_tri_V.xlsm

I don't see those results anywhere in that workbook.

4n_tri_V.xlsm

OK, let me see if I can figure out how this works.

There's some very clever code there.

I'll be back tomorrow.

A complaint I have about some coders is that when they create complicated code, they sometimes don't document that code and that can make it difficult for others (or themselves a few months later) to understand. That was the case with the 4n_tri_V workbook you supplied. Perhaps a better coder than I could have figured it out but I gave up and created and documented my own code which I understand. If you are interested in what I'm talking about then see my A Guide to Writing Understandable and Maintainable VBA Code article.

Check the results carefully because what you wanted was difficult to do.
29085662a.xlsm

MArtin

I really understand you on  this
You are an  Greater Expert  the Best !

after work with the solution

i found this

Great JOB !!

Best Expert !