<div>
Please explain the significance of the colors.<br />
<br />
Explique el significado de los colores.
</div>


<div>
the colors will be the same as the WEEK TOP NUM<br><br>green same week<br><br>red next week&nbsp;<br><br><br>
</div>


<div>
T5:T7 is a different color than T7:T8. Should they both be colored like T7:T8?
</div>


<div>
T5:T7 have the rigth color to be use<br><br>&nbsp;T7:T8 colors was my mistake
</div>


<div>
an very important detail is need the range be&nbsp; from MAYOR to MINOR&nbsp; when sort&nbsp;
</div>


<div>
<blockquote>
as we did here,,,
</blockquote>
Are you referring to a column in the 29216924b workbook? If so which one?
</div>


<div>
we did WEEK TOP NUM <br><br>now WK RANGE is needed<br><br>is the same way but now RANGE&nbsp;
</div>


<div>
Using the 50 range for an example, how many pairs in the range 50 to 59 do there need to be in order to show it on the worksheet?
</div>


<div>
sorry i dont&nbsp; understand the question
</div>


<div>
but the range in sheet 1 RANGE PAIRS button&nbsp; is working as needed &nbsp;
</div>


<div>
<blockquote>
the range in sheet 1 RANGE PAIRS button &nbsp;is working as needed &nbsp;
</blockquote>
Which one?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562578/2021-06-02_16-23-18.png" target="_blank" title="2021-06-02_16-23-18.png (148 KB)"><img alt="2021-06-02_16-23-18.png" class="file-block lazyload" style="max-width: 632px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562578/2021-06-02_16-23-18.png" /></a>
</div>


2021-06-02_16-23-18.png

<div>
I don't undestand what &nbsp;you shows in that pic<br><br>but as shows here<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562580/ex36.PNG" rel="ugc nofollow"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562580/ex36.PNG"></a><br><br><br>
</div>


ex36.PNG

<div>
If a pair is in this week <i>and</i> next week should it be green <i>and</i> red?<br />
<br />
Have you considered using the same colors as WEEK TOP NUM?
</div>


<div>
<blockquote>Have you considered using the same colors as WEEK TOP NUM?&nbsp;</blockquote><br>Please use &nbsp;them<br><br><br><blockquote><blockquote>If a pair is in this week <em>and</em> next week should it be green <em>and</em> red?&nbsp;</blockquote></blockquote><br>Green is the first always<br><br>
</div>


<div>
Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'R'?<br />
Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'AE'?
</div>


<div>
Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'R'?<blockquote>Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'AE'?&nbsp;</blockquote><br>yes, please !!
</div>


<div>
Just to keep you up to date; I'm having some difficulties with this but I'll figure it out eventually.<br />
<br />
Solo para mantenerte actualizado; Estoy teniendo algunas dificultades con esto, pero eventualmente lo resolveré.
</div>


<div>
I have a question about WEEK TOP NUM. Look at column 'F' for 1W2012 (and every week where there is no AM data). Notice that the numbers are 9,8,7,6,5,4,3,2,1,0 ( the digits are in descending order). Is that correct?<br />
<br />
Tengo una pregunta sobre WEEK TOP NUM. Mire la columna 'F' para 1W2012 (y todas las semanas donde no hay datos AM). Observe que los números son 9,8,7,6,5,4,3,2,1,0 (los dígitos están en orden descendente). ¿Es eso correcto?
</div>


<div>
&nbsp;Is that correct?<br><br>yes! sort in descending is the way&nbsp;
</div>


<div>
But A5 is blank, so what does 9,8,7,6 represent?<br />
<br />
Pero A5 está en blanco, entonces, ¿qué representa 9,8,7,6?
</div>


<div>
What should column 'F' for 25W2013 look like?
</div>


<div>
What should column 'F' for 25W2013 look like? <br><br>NO ORD in MON AM so should be blank<br>&nbsp;&nbsp;
</div>


<div>
I'm sorry but I realize now that I don't fully understand how to calculate the numbers in WEEK TOP NUM, so I need you to explain again, In 26W2013 I'd like you to explain where each the numbers in columns 'F' and 'G' come from. Your explanation should include a statement like &quot;The 9 in cell F1006 comes from...&quot;<br />
<br />
Lo siento, pero ahora me doy cuenta de que no entiendo completamente cómo calcular los números en WEEK TOP NUM, así que necesito que me expliques nuevamente, en 26W2013 me gustaría que explicaras dónde están los números en las columnas 'F 'y' G 'provienen de. Su explicación debe incluir una declaración como &quot;El 9 en la celda F1006 proviene de ...&quot;
</div>


<div>
Please explain if that's ok ?<br><br>
</div>


<div>
I see that 9,8,32 comes from C1006 but why is it in that order? Where does 7.6.5.4.1.0 come from?
</div>


<div>
when &nbsp;the week is begining<br><br>2839 shows up then you hit the ONE TOP COUNT<br>then it count the 2839<br><br>it sort the count descending<br>&nbsp; that is the count&nbsp;<br><br><br>
</div>


<div>
What I asked you do do was thais:<br />
<br />
I need you to explain again, In 26W2013 I'd like you to <b>explain where each the numbers in columns 'F' and 'G' come from</b><br />
<br />
Necesito que me expliques de nuevo. En 26W2013, me gustaría que <b>explicaras de dónde provienen los números de las columnas 'F' y 'G'</b>
</div>


<div>
<blockquote>
 sorry i did
</blockquote>
Where?<br />
<br />

<blockquote>
here you can review it
</blockquote>
The explanation there is too long and too confusing and that's why I started asking you again.
</div>


<div>
wells i don't knows what is confused to you<br>because you don't explain me where you are lost...<br><br>you just ask explain all over again<br><br>i closed &nbsp;an question as good solution<br>for the same question here &nbsp;you are asking<br><br>may be you should goes step by step so i can see where is the step<br>you are missing<br><br>i undestand the person lost is you not me<br><br>is very easy at this point say start all over again<br>just because i get lost<br><br>you should explian where did you get lost and why<br><br>like you say<blockquote>I need you to explain again,&nbsp;</blockquote>means to me you knows i explain this already<br><br>if you don't want finish this question<br>i understand we can leaves this here<br><br><br>
</div>


<div>
<blockquote>
wells i don't knows what is confused to you<br />
because you don't explain where you are lost..
</blockquote>
Assume that I don't know anything.<br />
<br />

<blockquote>
i closed &nbsp;an question as good solution<br />
for the same question here &nbsp;you are asking
</blockquote>
But it was wrong for some of the AM time periods.<br />
<br />

<blockquote>
i understand we can leaves this here
</blockquote>
That is up to you but it should be a simple thing to explain where <b><u>all</u></b> the numbers in 26W2013 columns F and G come from.
</div>


<div>
we (not you alone) have worked together for many years many solutions<br><br>I think if I ask you to explain to me where you got lost<br>and that you go step by step explaining to me<br>Where did you stay, you can do it to understand why you don't understand<br><br>and to be more effective and save time<br><br>I have explained many things to you, so with my problems and my limitations and my poor command of the language<br>&nbsp;<br>do not come to treat me as if I<br>a stupid person<br><br>and answer me when I ask you a question<br>with details and clarity<br><br>I have always been willing to cooperate and help and it is not for less that my time is despised<br><br>as I'm not interested in wasting your time either
</div>


<div>
<blockquote>
do not come to treat me as if I<br />
a stupid person
</blockquote>
When did I do that?<br />
<br />
In any case in your <a href="https://www.experts-exchange.com/questions/29216924/4N-Count-By-each-Section.html" rel="ugc">4N Count By each Section</a> question you said<br />

<blockquote>
example : Monday am = count Monday AM (the begining)<br />
<br />
Monday PM = count Monday AM + Monday PM<br />
<br />
Tuesday AM = Monday AM + MONDAY PM + Tuesday AM = <br />

</blockquote>
<br />
So in 26W2013 for example, the Monday AM ORD is 2839. What exactly should I count for column 'F'?
</div>


<div>
I understand that Monday AM is 2838, but what am I counting that results in 9832765410?
</div>


<div>
For 26W2013:<br />
<br />
For Monday AM I count how many times 2 and 8 and 3 and 9 occur in 2839.<br />
For Monday PM I count... ?
</div>


<div>
Are you reading my messages?<br>or do you just look at them?
</div>


<div>
Do i have to repeat the SAME again ??
</div>


<div>
I read them.<br />
<br />
All I need you to do is to complete this sentence<br />
<br />
For Monday PM I count... ?<br />
<br />
just like it did in this sentence<br />
For Monday AM I count how many times 2 and 8 and 3 and 9 occur in 2839.
</div>


<div>
I don't understand what you're trying to do<br>if I have to answer the questions only&nbsp; your way<br>Or are you ridiculing me because I don't see things like you<br>or is this a power struggle?<br><br>I try to explain the best that I can<br><br>as I have repeated before<br>&nbsp;<br>&nbsp; MON PM = MON AM + MON PM<br><br>how many times you see 2 in 2839 MON AM<br><br>just 1 ??
</div>


<div>
<blockquote>
Or are you ridiculing me because I don't see things like you<br />
or is this a power struggle?
</blockquote>
I would <u>never</u> do that. <br />
<br />
I just want to be 100% sure what you mean by &quot;counting&quot; and I'm not. &nbsp;<br />
<br />
I know the numbers are shown in descending or of there occurrence count.<br />
<br />
Are you saying that for column 'F' I count how many times the digits of the first ORD appear in the week? If so then I need you to write a sentence <u>just like that one</u> that says what I do for column G.<br />
<br />
Yo nunca haría eso.<br />
<br />
Solo quiero estar 100% seguro de lo que quieres decir con &quot;contar&quot; y no lo estoy.<br />
<br />
Sé que los números se muestran en forma descendente o de recuento de ocurrencias.<br />
<br />
¿Está diciendo que para la columna 'F' cuento cuántas veces aparecen los dígitos del primer ORD en la semana? Si es así, necesito que escribas una oración <u>como esa</u> que diga lo que hago para la columna G.
</div>


<div>
sorry! you did&nbsp;<br>the solution was done correctly<br>i never said it was wrong<br><br>why you now say you don't undestand something you already did?<br><br>and you did well!<br><br>why don't you explain that to me?
</div>


<div>
I didn't even say change some of that<br><br>you did that solution correctly<br><br>because if you're doing the same, you tell me you don't understand
</div>


<div>
<blockquote>
why you now say you don't undestand something you already did?
</blockquote>
I'm an old man.<br />
<br />

<blockquote>
for column 'F' I count how many times the digits of the first ORD appear in the week
</blockquote>
Why haven't you done what I've asked for several times and that is to write a sentence like that for column G?
</div>


<div>
ok i apologize to you<br>&nbsp; I don't know how to write that my english is not so good<br><br>okay. give me an sample to follow<br><br>
</div>


<div>
<blockquote>Are you saying that for column 'F' I count how many times the digits of the first ORD appear in the week? If so then I need you to write a sentence <u>just like that one</u> that says what I do for column G.&nbsp;</blockquote><br>i don't Understand this <br><br>can you make more simple to me so i can write the sentence?
</div>


<div>
Do you understand the following sentence?<br />
For column 'F' I count how many times the digits of the first ORD appear in the week.
</div>


<div>
It tells me what digits to count and where I should look to count them.<br />
<br />
Me dice qué dígitos contar y dónde debo mirar para contarlos.
</div>


<div>
Sorry &nbsp;I'm sorry I don't want to sound spoiled or anything like that<br><br>but i don't understand the question<br><br>you now you have to look and ORD (column BF)<br>26W2013 &nbsp;MON AM &nbsp;2839 &nbsp;<br><br>when in sheet1<br><br>then i hit &nbsp;ONE COUNT TOP button in columns DX&nbsp;
</div>


<div>
How does ONE COUNT TOP help me fill in <u>column G</u> or any of the other columns in WEEK TOP COUNTon the BYPLAY sheet?<br />
<br />
¿Cómo me ayuda ONE COUNT TOP a completar <u>la columna G</u> o cualquiera de las otras columnas de WEEK TOP COUNT en la hoja BYPLAY?
</div>


<div>
You didn't answer my question.
</div>


<div>
<blockquote>How does ONE COUNT TOP help me fill in <u>column G</u> or any of the other columns in WEEK TOP COUNTon the BYPLAY sheet? &nbsp;</blockquote>like i say is the counter<br><br>but in BYPLAY<br><br>have to be record &nbsp;by each appearance
</div>


<div>
Sorry i dont undestand you question give an example <br>of the answer to follow
</div>


<div>
I did.<br />
<br />

<blockquote>
For column 'F' I count how many times the digits of the first ORD appear in the week.
</blockquote>
<br />
and I need something like that for column G that tells me which ORDs to count and where to count them. So something like &quot;For column 'G' you need to count how many times the digits of the first two ORDs appear in the week.&quot;
</div>


<div>
<br>23W2013<br>MON AM &nbsp;=2839 &nbsp;count it &nbsp;in column F &nbsp;( it appear 1 times<br>MON PM =2839 + 2619 count each digit and appear in column G ( count each digit and shows in columns G)<br><br>
</div>


<div>
<blockquote>
2839 + 2619
</blockquote>
That's <u>what</u> to count but you haven't told me <u>where to look</u> to count them. <br />
Should I look in all the ORDS for the whole week (BF1006 to BF1017? If not then which rows? Please don't refer me to ONE COUNT TOP.
</div>


<div>
you should &nbsp;goes to BY PLAY sheet<br><br>then count ORD is Column C<br>each week is an set<br>it beging with MON AM<br>we talk about 26W2013 &nbsp;then you have to goes at the firts apperance then add the follow<br>(Increment) until the week is finish (the week finish &nbsp;at SAT OM
</div>


<div>
Please just answer yes or no. Should I always look in all the ORDS for the whole week (BF1006 to BF1017?
</div>


29217378.xlsb

ACCOUNTING ASSISTANT

ADRIANA P

<div>
Is an Great Job &nbsp;im testing it<br><br>rainbow is an great&nbsp; Name too!
</div>


<div>
For 1W2012 <br />
<br />
Is it true that when I do MON (PM) I count the occurrences of 4 and 6 and 1 and 9 in column 'A', rows 5 to 16 on the BYPLAY sheet?<br />
Is it true that when I do TUE (PM) I count the occurrences of 4 and 6 and 1 and 9 and 8 and 3 in column 'A', rows 5 to 16 on the BYPLAY sheet?<br />
<br />
<br />
Para 1W2012<br />
<br />
¿Es cierto que cuando hago MON (PM) cuento las apariciones de 4 y 6 y 1 y 9 en la columna 'A', filas 5 a 16 en la hoja BYPLAY?<br />
¿Es cierto que cuando hago TUE (PM) cuento las ocurrencias de 4 y 6 y 1 y 9 y 8 y 3 en la columna 'A', filas 5 a 16 en la hoja BYPLAY?
</div>


<div>
You didn't answer my questions and I don't understand what you mean by &quot;... i lost the keys...&quot;.
</div>


<div>
<blockquote>Is it true that when I do MON (PM) I count the occurrences of 4 and 6 and 1 and 9 in column 'A', rows 5 to 16 on the BYPLAY sheet?</blockquote><br>why column A? <br><br>yes count the ocurrences in Column C in BY PLAY sheet<br><blockquote>Is it true that when I do TUE (PM) I count the occurrences of 4 and 6 and 1 and 9 and 8 and 3 in column 'A', rows 5 to 16 on the BYPLAY sheet?&nbsp;</blockquote><br>Yes count the ocurrences in Column C ByPLAy sheet<br><br>but you are making an error<br><br>you have to go to the Number by DAy By AM PM<br><br><br>
</div>


<div>
Why &nbsp;you don't goes to the each number as i shows in the PIc is not better ?
</div>


<div>
<blockquote>
why column A? 
</blockquote>
I meant 'C'.<br />
<br />

<blockquote>
you have to go to the Number by DAy By AM PM
</blockquote>
I don't know what that means.
</div>


<div>
<blockquote>
Why &nbsp;you don't goes to the each number as i shows in the PIc is not better 
</blockquote>
?Because you told me what to search but not where.
</div>


<div>
ok i will explain something but will need you help please<br>i need goes setp by step<br>is ok to you ?
</div>


<div>
please let me knows if i explain this MON PM good to go?
</div>


<div>
may be you are tired for today<br>are you in rest already?<br>i just try to explain in the best moment
</div>


<div>
Not really but you can post now and as soon as I'm available I'll take a look at it.
</div>


<div>
Thank you very much for all your help and friendship for so long<br>I have no one to help me so much in my time<br>and less like you<br><br>I would like to make things work and I think I make my mistakes in my communication with the person who helps me the most<br><br>I do not know how to explain what I see, I would like to be able to talk without limitations<br><br>My best effort has been trying to convey the direction to you in the best way I can so as not to get stuck in something and move forward.<br><br>I apologize for my mistakes in my endeavor<br>It does not matter what is achieved, the most important thing for me has been to have a great friend like you in my desire to achieve this project.
</div>


<div>
i like the improves you dis to this file you did they are great and needed<br><br>is ok elimante the count where not AM is in ORD present (not ORD present) but need the key from <a href="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562806/29216924a.xlsb" rel="ugc">29216924a.xlsb</a>&nbsp;<br><br>this file have the WEEK TOP NUM as needed &nbsp;<a href="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562806/29216924a.xlsb" rel="ugc">29216924a.xlsb</a><br><br><br><br><br>
</div>


29216924a.xlsb

<div>
I'm happy to work with you.<br />
<br />
Are you saying that these are the numbers you want to see?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562807/2021-06-05_20-20-57.png" target="_blank" title="2021-06-05_20-20-57.png (191 KB)"><img alt="2021-06-05_20-20-57.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w23/800_1562807/2021-06-05_20-20-57.png" /></a>
</div>


2021-06-05_20-20-57.png

<div>
Do you have a copy of the workbook that put 9,8,7,6,5,4,3,2,1,0 in the AM periods of 1W2012?
</div>


29217156--1-.xlsb

<div>
Thanks.<br />
<br />
I've been working on WEEK TOP NUM for days and I'm finding it to be very difficult, and at some point I may have to say that I don't know how to do it.<br />
<br />
He estado trabajando en WEEK TOP NUM durante días y lo encuentro muy difícil, y en algún momento debo decir que no sé cómo hacerlo.
</div>


<div>
I understand but it is already done in this file as I need it, you could not do the best ones keeping the way in which the counter of this file works? 29217156 (1) .xlsb
</div>


<div>
any way we can keep going with others situations no problem to me<br><br>
</div>


<div>
Please check the results in this picture.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w24/1562835/2021-06-06_18-07-53.png" target="_blank" title="2021-06-06_18-07-53.png (126 KB)"><img alt="2021-06-06_18-07-53.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w24/800_1562835/2021-06-06_18-07-53.png" /></a>Are the counts correct?<br />
<br />
Should the key be 99999 rather than 999999999999?
</div>


2021-06-06_18-07-53.png

<div>
Martin<br><br>the key is ok because is the ALL TOP<br><br>but the counts are not To Go<br><br>I'm going to propose something to you<br><br>this file has been a great experience<br><br>let me develop other alternatives<br><br>what I have thought and this we can leave it for finished<br><br>I have other ideas that are more practical and less tedious<br><br><br>
</div>


<div>
I have others ideas to&nbsp; try
</div>


<div>
<blockquote>
but the counts are not To Go
</blockquote>
I'm not sure what that means but aren't the counts in the first two columns the same as in your picture?
</div>


<div>
<div class="content wysiwyg-content fr-view">
4N KwP &nbsp;add &nbsp;R increments<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562539/29217266a.xlsb" rel="ugc">29217266a.xlsb</a><br><br>as we did here but now for &nbsp;this file<br><a href="https://www.experts-exchange.com/questions/29216924/4N-Count-By-each-Section.html" rel="ugc">https://www.experts-exchange.com/questions/29216924/4N-Count-By-each-Section.html</a><br><br>1- Sheet "BYPLAY" will be the output WK RANGE<br><br>&nbsp;<br><br>2- an button by each hit to count AM &nbsp;AND PM &nbsp;by DAY<br><br>example : Monday am = count Monday AM (the begining)<br><br>Monday PM = count Monday AM + Monday PM<br><br>Tuesday AM = Monday AM + MONDAY PM + Tuesday AM =<br><br><br><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562541/ex35.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w23/1562541/ex35.PNG" class="fr-fic fr-dib"></a>&nbsp;
</div>
</div>


29217266a.xlsb

ex35.PNG


4N KwP  add  R increments
29217266a.xlsb
as we did here but now for  this file
https://www.experts-exchange.com/questions/29216924/4N-Count-By-each-Section.html
1- Sheet "BYPLAY" will be the output WK RANGE
 
2- an button by each hit to count AM  AND PM  by DAY
example : Monday am = count Monday AM (the begining)
Monday PM = count Monday AM + Monday PM
Tuesday AM = Monday AM + MONDAY PM + Tuesday AM =
 

4N R  Count increments  by DAY

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.

Microsoft Excel

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.