Button to show the TRI 4N WK

column BF is the source
it have an 13 rows (1set)

then need  the  TRI repeat (2 or more )
 for each set
and show in column  CJ and the count in column CK
29085562--1-_range_ok_4N.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
You didn't attach a workbook.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
sorry !

upload now
0
Martin LissOlder than dirtCommented:
If BF is the source, why do you call this "TRI", meaning three?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
If BF is the source, why do you call this "TRI", meaning three?

Yes
because are three digit repeat
0
Martin LissOlder than dirtCommented:
What should the result be for this week?
2018-02-23_12-45-12.png
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

this is the  result for the week 13w20112

2222222222.PNG

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

33333333333333333333333333333.PNG
here the result

5555555555555555555555555555.PNG

but just the count of 2 or more are post in column CJ and the count column CK
0
Martin LissOlder than dirtCommented:
Try this.
29085662.xlsm
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin Great JOb  !!

have this situacion

this the count for  31W2013

bbb1111.PNG
215   and   413 don't showup


22222bbbbbbbbb.PNG
0
Martin LissOlder than dirtCommented:
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"?
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
If the 4-digit number were 5162, does that contain "215"

yes but the order is the law
0
Martin LissOlder than dirtCommented:
According to the "law" does 2615 contain both 215 and 615?
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

2aa.PNG

more easy
0
Martin LissOlder than dirtCommented:
Please attach a copy of the workbook that those results came from.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
0
Martin LissOlder than dirtCommented:
I don't see those results anywhere in that workbook.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
0
Martin LissOlder than dirtCommented:
OK, let me see if I can figure out how this works.
1
Martin LissOlder than dirtCommented:
There's some very clever code there.

I'll be back tomorrow.
1
Martin LissOlder than dirtCommented:
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
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

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

after work with the solution

i found this

cc111.PNG
0
Martin LissOlder than dirtCommented:
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB !!

Best Expert !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.