<div>
You didn't attach a workbook.
</div>


<div>
sorry !<br />
<br />
upload now
</div>


<div>
If BF is the source, why do you call this &quot;TRI&quot;, meaning three?
</div>


<div>
Martin<br />

<blockquote>
If BF is the source, why do you call this &quot;TRI&quot;, meaning three?
</blockquote>
<br />
Yes <br />
because are three digit repeat
</div>


<div>
What should the result be for this week?<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278100/2018-02-23_12-45-12.png" target="_blank" title="2018-02-23_12-45-12.png (10 KB)"><img alt="2018-02-23_12-45-12.png" class="file-block lazyload" style="max-width: 68px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278100/2018-02-23_12-45-12.png" /></a>
</div>


2018-02-23_12-45-12.png

<div>
Martin <br />
<br />
this is the &nbsp;result for the week 13w20112<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278106/2222222222.PNG" target="_blank" title="2222222222.PNG (5 KB)"><img alt="2222222222.PNG" class="file-block lazyload" style="max-width: 210px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278106/2222222222.PNG" /></a><br />
<br />
but not repeat is going so no data will be pickup<br />
<br />
we need have the 2 or more tri repeat <br />
as &nbsp;show in week 36W2013<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278113/33333333333333333333333333333.PNG" target="_blank" title="33333333333333333333333333333.PNG (56 KB)"><img alt="33333333333333333333333333333.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/800_1278113/33333333333333333333333333333.PNG" /></a><br />
here the result<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278110/5555555555555555555555555555.PNG" target="_blank" title="5555555555555555555555555555.PNG (6 KB)"><img alt="5555555555555555555555555555.PNG" class="file-block lazyload" style="max-width: 215px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278110/5555555555555555555555555555.PNG" /></a><br />
<br />
but just the count of 2 or more are post in column CJ and the count column CK
</div>


2222222222.PNG

33333333333333333333333333333.PNG

5555555555555555555555555555.PNG

29085662.xlsm

<div>
Martin Great JOb &nbsp;!!<br />
<br />
have this situacion <br />
<br />
this the count for &nbsp;31W2013<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278171/bbb1111.PNG" target="_blank" title="bbb1111.PNG (6 KB)"><img alt="bbb1111.PNG" class="file-block lazyload" style="max-width: 210px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278171/bbb1111.PNG" /></a><br />
215 &nbsp; and &nbsp; 413 don't showup<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278172/22222bbbbbbbbb.PNG" target="_blank" title="22222bbbbbbbbb.PNG (154 KB)"><img alt="22222bbbbbbbbb.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/800_1278172/22222bbbbbbbbb.PNG" /></a>
</div>


22222bbbbbbbbb.PNG

bbb1111.PNG

<div>
I thought you were looking for &quot;215&quot; rather than the 215 in 2615 (for example). <br />
<br />
If the 4-digit number were 5162, does that contain &quot;215&quot;?
</div>


<div>
MArtin <br />
<br />
The source column BF <br />
is and have to be always in the order<br />
<br />
2,4,6,8,0 &nbsp;then &nbsp; 1 ,3 ,5,7,9<br />
<br />
<br />
If i understasnd your question <br />
<br />
that will be always the order<br />
<br />
not other order can be for column BF
</div>


<div>
<blockquote>
If the 4-digit number were 5162, does that contain &quot;215&quot;
</blockquote>
<br />
yes but the order is the law
</div>


<div>
According to the &quot;law&quot; does 2615 contain both 215 and 615?
</div>


<div>
Martin<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278191/2aa.PNG" target="_blank" title="2aa.PNG (10 KB)"><img alt="2aa.PNG" class="file-block lazyload" style="max-width: 618px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278191/2aa.PNG" /></a><br />
<br />
more easy
</div>


2aa.PNG

<div>
Please attach a copy of the workbook that those results came from.
</div>


4n_tri_V.xlsm

<div>
I don't see those results anywhere in that workbook.
</div>


<div>
OK, let me see if I can figure out how this works.
</div>


<div>
There's some <i>very</i> clever code there. <br />
<br />
I'll be back tomorrow.
</div>


<div>
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 href="http://rdsrc.us/NLTOxf" rel="ugc">A Guide to Writing Understandable and Maintainable VBA Code</a> article.<br />
<br />
Check the results carefully because what you wanted was difficult to do.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278381/29085662a.xlsm" target="_blank" class="file-inline" title="29085662a.xlsm (3.1 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>29085662a.xlsm</a>
</div>


29085662a.xlsm

<div>
MArtin <br />
<br />
I really understand you on &nbsp;this<br />
You are an &nbsp;Greater Expert &nbsp;the Best !<br />
<br />
after work with the solution <br />
<br />
i found this <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1278385/cc111.PNG" target="_blank" title="cc111.PNG (165 KB)"><img alt="cc111.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w08/800_1278385/cc111.PNG" /></a>
</div>


cc111.PNG

29085662c.xlsm

<div>
Great JOB !!<br />
<br />
Best Expert !
</div>


<div>
<div class="content wysiwyg-content">
column BF is the source <br />
it have an 13 rows (1set)<br />
<br />
then need &nbsp;the &nbsp;TRI repeat (2 or more )<br />
&nbsp;for each set<br />
and show in column &nbsp;CJ and the count in column CK<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w08/1277960/29085562--1-_range_ok_4N.xlsm" target="_blank" class="file-inline" title="29085562--1-_range_ok_4N.xlsm (2.8 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>29085562--1-_range_ok_4N.xlsm</a>
</div>
</div>


29085562--1-_range_ok_4N.xlsm

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

Button to show the TRI 4N WK

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.