<div>
In what order are the range counts shown; ascending or descending?<br />
How many hits in a range are necessary for the range to be shown; more than 0 or more than 1?<br />
<br />
En qué orden se muestran los recuentos de rango; ascendente o descendente?<br />
Cuántos aciertos en un rango son necesarios para que se muestre el rango; más de 0 o más de 1?
</div>


<div>
<blockquote>ascending or descending?</blockquote><br>always &nbsp;descending<br>&nbsp;<blockquote>more than 0 or more than 1?</blockquote><br>&nbsp;<br>more than 0 <br><br><br>
</div>


<div>
I have the range counts working. Now I need to apply the colors. It may take me a day or two to do that because I have personal things to do.<br />
<br />
BTW, I could argue that the ranges in your picture are in ascending order from the top since the ones with the highest counts are at the bottom.<br />
<br />
Tengo los recuentos de rango funcionando. Ahora necesito aplicar los colores. Puede que me lleve uno o dos días hacerlo porque tengo cosas personales que hacer.<br />
<br />
Por cierto, podría argumentar que los rangos en su imagen están en orden ascendente desde la parte superior, ya que los que tienen los conteos más altos están en la parte inferior.
</div>


<div>
I actually have some time now so please explain why in column 'V' the 10 range is green and the 40 range is red.
</div>


<div>
You are rigth range is ascendent<br><br>actually as the button in sheet1 range<br><br>color as in Week TOP &nbsp;Num<br><br>green same week<br><br>ligth red in the next week
</div>


<div>
I understand that green indicates that there's a match this week, but what cell does the 10 match? <br />
<br />
Entiendo que el verde indica que hay una coincidencia esta semana, pero ¿qué celda coincide con el 10?
</div>


<div>
In this picture the ranges in a week are only compared with the ranges in the next week. I have not yet done the comparison in the current week. Please tell me if this is correct so far. If you find one cell that isn't colored correctly then stop looking and tell me the cell address of the incorrect cell and why it isn't correct.<br />
<br />
En esta imagen, los rangos en una semana solo se comparan con los rangos en la próxima semana. Todavía no he hecho la comparación en la semana actual. Por favor, dígame si esto es correcto hasta ahora. Si encuentra una celda que no tiene el color correcto, deje de buscar y dígame la dirección de la celda incorrecta y por qué no es correcta.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563189/2021-06-13_08-33-49.png" target="_blank" title="2021-06-13_08-33-49.png (417 KB)"><img alt="2021-06-13_08-33-49.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w25/800_1563189/2021-06-13_08-33-49.png" /></a>
</div>


2021-06-13_08-33-49.png

<div>
v5 v6 are not correct<br>because no pair with 81 &nbsp;or 48 &nbsp;in the next week
</div>


<div>
In your original question you said<br />

<blockquote>
count Range
</blockquote>
<br />
Aren't we comparing ranges and not pairs? There's a 10 range in C27 and an 80 range in C23, If you really want to check pairs then there's a problem because I don't think I know how to tell that the 10 range was added because of 81.<br />
<br />
En tu pregunta original dijiste<br />

<blockquote>
rango de recuento
</blockquote>
<br />
¿No estamos comparando rangos y no pares? Hay un rango de 10 en C27 y un rango de 80 en C23. Si realmente desea verificar pares, entonces hay un problema porque no creo que sepa cómo decir que el rango de 10 se agregó debido a 81.
</div>


<div>
Also in your picture you show T5 as red. The 10 range in T5 came from C10 and there's no 13 in 2W2012 so why is it red?<br />
<br />
También en su imagen muestra T5 en rojo. El rango 10 en T5 provino de C10 y no hay 13 en 2W2012, entonces, ¿por qué es rojo?
</div>


<div>
<blockquote>
Don't see it as an 10 because it does't
</blockquote>
no te entiendo
</div>


<div>
sorry why i have to repeat again ?
</div>


<div>
Because I don't understand what &quot;Don't see it as an 10 because it does't&quot; means.
</div>


<div>
you can CALL this the COLOR for HIts for RANGE&nbsp;
</div>


<div>
<blockquote>
10 = 1 &nbsp;same for all others
</blockquote>
Yes, I understand that but then you say &quot;pair with 81 &nbsp;or 48&quot;. If 10 = 1 why are you referring to pairs???????
</div>


<div>
Create RANGE is one step ( youdid Excellent)<br><br>then color RANGE &nbsp;will be other Step (different)<br><br>looks to be the same but is not
</div>


<div>
Frequently I have difficulty understanding what you are saying and I believe that that is because you don't use Google Translate. I've attached a video which shows how to use it. What I need you to do is to start at the beginning and enter a full and complete description of all of the requirements in Spanish and then paste the English translation here.<br />
<br />
Con frecuencia tengo dificultades para entender lo que estás diciendo y creo que se debe a que no utilizas Google Translate. Adjunto un video que muestra cómo usarlo. Lo que necesito que haga es comenzar por el principio e ingresar una descripción completa y completa de todos los requisitos en español y luego pegar la traducción al inglés aquí.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563200/2021-06-13_11-36-49.mp4" target="_blank" class="file-inline" title="2021-06-13_11-36-49.mp4 (742 KB)"><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>2021-06-13_11-36-49.mp4</a>
</div>


2021-06-13_11-36-49.mp4

<div>
Step 2 needs a lot more explanation.
</div>


<div>
I have to insist that you use Google Translate.
</div>


<div>
the only difference is a we need to look at 10 = 1<br><br>20 = 2<br><br>and so for all the other numbers that form the RANGE<br><br>It is the only difference, from that everything is similar to WEEK TOP NUM
</div>


<div>
I'm sorry Adriana, but I don't know how to do what you want because I have no way of knowing what pair values caused the ranges to appear.
</div>


29218073.xlsb

ACCOUNTING ASSISTANT

ADRIANA P

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


<div>
another way to see this is like this:<br><br>1- in the range column the value on the left is taken only<br><br>2- Taking only the value on the left, the same thing that was done in WEEK TOP NUM is done to make the match with ORD<br><br>the pairs or tri &nbsp;or &nbsp;4 digits &nbsp; in sequence are identified &nbsp;in ORD (as Done in WEEK TOP NuM)<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563217/ex50.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563217/ex50.PNG" class="fr-fic fr-dii"></a><br>
</div>


ex50.PNG

<div>
Okay but how does that result in 40 and 60 being red?
</div>


<div>
1- as you are only taking into account the values of the Left<br><br>they would be like this<br><br>1<br>8<br>4<br>6<br><br>we are looking for the sequence that are present in ORD in the same week or the following week in this example<br><br>sequence 64<br><br>we always look at the RANGE from the bottom up<br><br>6 4 is a sequence 48 is another sequence 81 is another sequence<br><br><br>but in this example in the second week we see a sequence of 46 in the ORD column for the second week and it is red because it is the second week<br><br><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563218/ex51.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563218/ex51.PNG" class="fr-fic fr-dib"></a>
</div>


ex51.PNG

<div>
So are you saying that I should<br />
First &nbsp;look for 1 and 8 and not find a match<br />
Then look for 8 and 4 and not find a match (actually 4 and 8 since the ORDs are in ORD sequence)<br />
Then look for 4 and 6 and find a match?
</div>


<div>
Please remind me of something. If I'm coloring the ranges in column Z (THU PM) of 1W2012 based on what's in 2W2012, do I compare the 1st characters of the ranges with the ORDs starting with week 2 (MON AM) or starting with week 2 FRI AM?<br />
<br />
Por favor, recuérdame algo. Si estoy coloreando los rangos en la columna Z (THU PM) de 1W2012 según lo que hay en 2W2012, ¿comparo los primeros caracteres de los rangos con los ORD que comienzan con la semana 2 (MON AM) o comienzan con la semana 2 FRI AM?
</div>


<div>
This assumes that I always compare the ranges with <i>all</i> the ORDs of the next week. If there is a cell that's wrong please tell me the cell address and why it is wrong.<br />
<br />
Esto supone que siempre comparo los rangos con <i>todos</i> los ORD de la próxima semana. Si hay una celda incorrecta, por favor dígame la dirección de la celda y por qué es incorrecta.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563280/2021-06-14_12-44-36.png" target="_blank" title="2021-06-14_12-44-36.png (415 KB)"><img alt="2021-06-14_12-44-36.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w25/800_1563280/2021-06-14_12-44-36.png" /></a>
</div>


2021-06-14_12-44-36.png

<div>
as shows<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563294/ex52.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563294/ex52.PNG" class="fr-fic fr-dib"></a>
</div>


ex52.PNG

<div>
Okay I thought we were looking for pairs like &quot;23&quot;, but now it looks like we are looking for &quot;2&quot; and &quot;3&quot;. Correct?
</div>


<div>
Better?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563298/2021-06-14_17-36-59.png" target="_blank" title="2021-06-14_17-36-59.png (347 KB)"><img alt="2021-06-14_17-36-59.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w25/800_1563298/2021-06-14_17-36-59.png" /></a>
</div>


2021-06-14_17-36-59.png

<div>
<blockquote>Okay I thought we were looking for pairs like "23", but now it looks like we are looking for "2" and "3". Correct?&nbsp;</blockquote><br>not.<br><br>23 is an Pair in 2883 &nbsp; &nbsp;28 83 &nbsp;23 &nbsp;88 <br><br>is not 2 and 3 as an Digit &nbsp;alone <br><br><br>we look for pairs, &nbsp;tri&nbsp; or qua
</div>


<div>
<blockquote>Better?&nbsp;</blockquote><br>yes is better!!<br>but missing somes
</div>


<div>
In TUE PM for week 1 there are an even number of ranges, in this case 4.<br />
10<br />
80<br />
40<br />
60<br />
<br />
If I understand the requirements I need to search the ORDs for 81, 48 and 46. Those are the numbers that represent the ordered version of the first characters of 10 and 80, 80 and 40, and 40 and 60.<br />
<br />
But what do I do when there are an odd number of ranges like in MON PM of week 1 where these the ranges?<br />
10<br />
60<br />
40<br />
<br />
In this case I believe I should search for 61 and 46, but there's nothing after the 40 so do I search for just 4?<br />
<br />
En TUE PM para la semana 1 hay un número par de rangos, en este caso 4.<br />
10<br />
80<br />
40<br />
60<br />
<br />
Si entiendo los requisitos, necesito buscar en los ORD 81, 48 y 46. Esos son los números que representan la versión ordenada de los primeros caracteres de 10 y 80, 80 y 40, y 40 y 60.<br />
<br />
Pero, ¿qué hago cuando hay un número impar de rangos como en el lunes por la tarde de la semana 1 donde estos son los rangos?<br />
10<br />
60<br />
40<br />
<br />
En este caso, creo que debería buscar 61 y 46, pero no hay nada después de 40, así que ¿busco solo 4?
</div>


<div>
<blockquote>In this case I believe I should search for 61 and 46, but there's nothing after the 40 so do I search for just 4?&nbsp;</blockquote>No<br><br>we just look for pairs TRi or Qua<br><br><br>but you give an great idea with this situation<br><br><br>a question<br><br>Could you show the numbers in red of those fields that have not been left<br><br>for example MON PM<br><br>10<br>60<br>40<br><br>these are the ranks that came out<br><br>but the ones that did not come out are in RED<br><br>00<br>90<br>80<br>70<br>50<br>30<br>20<br><br>these would go like this<br><br>00<br>90<br>80<br>70<br>50<br>30<br>20<br>10<br>60<br>40<br><br><br>and so we can see more where the blows come from
</div>


<div>
<blockquote>
No<br />
<br />
we just look for pairs TRi or Qua
</blockquote>
what does &quot;pairs Tri or Qua&quot; mean?<br />
<br />

<blockquote>
Could you show the numbers in red of those fields that have not been left
</blockquote>
No, not now. Let me first try and do what you originally asked for.
</div>


<div>
Is what I said about TUE PM correct? <br />
You need to explain to me how the 40 in T7 becomes red.<br />
<br />
¿Es correcto lo que dije sobre TUE PM?<br />
Necesitas explicarme cómo el 40 en T7 se vuelve rojo
</div>


<div>
<blockquote>what does "pairs Tri or Qua" mean?&nbsp;</blockquote><br>pairs = 2 sequences &nbsp;up or down<br><br>Tri = 3 sequences up or down<br><br>qua = 4 sequences up or down<br><br><br>in the ranges the left side is the way &nbsp; for coloring the match<br><br><br>you can't use 40 or any range number alone<br><br>1<br>6<br>4 &nbsp; &nbsp;= &nbsp;61 &nbsp;, 46 &nbsp; in ord &nbsp;nothing more &nbsp; &nbsp;<br><br><br>1<br>6<br>4 &nbsp; = 461 &nbsp;TRI &nbsp;( 3 digits in sequence)<br><br><br>so 40 &nbsp;with 60 with 10 is &nbsp;TRI<br><br>461<br><br><br>QUAD are 4 digits sequence&nbsp;<br><br><br><br><br><br><br><br>
</div>


<div>
Necesitas explicarme cómo el 40 en T7 se vuelve rojo
</div>


<div>
<blockquote>You need to explain to me how the 40 in T7 becomes red.&nbsp;</blockquote><br>is red because &nbsp;is in the next week &nbsp;and is making 46 pair in ORD num 4617 &nbsp;<br><br>as shows:<a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563372/ex53.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563372/ex53.PNG" class="fr-fic fr-dib"></a><br><br><br><br>
</div>


ex53.PNG

<div>
you can't use 40 or any range number alone<br><br>1<br>6<br>4 &nbsp; &nbsp;= &nbsp;61 &nbsp;, 46&nbsp; PAIRS&nbsp; in ord &nbsp;nothing more &nbsp; &nbsp;<br><br><br>1<br>6<br>4 &nbsp; = 461 &nbsp;TRI &nbsp;( 3 digits in sequence)<br><br><br>so 40 &nbsp;with 60 with 10 is &nbsp;TRI<br><br>461<br><br><br>QUAD are 4 digits sequence &nbsp;
</div>


<div>
Oh, I never understood before what &quot;up and down&quot; meant in this question. <br />
<br />
As for TRI and QUAD, can you show me an example where a cell would get colored <u>only</u> because there was a TRI or QUAD match?<br />
<br />
Oh, nunca antes había entendido lo que significaba &quot;up and down&quot; en esta pregunta.<br />
<br />
En cuanto a TRI y QUAD, ¿puede mostrarme un ejemplo en el que una celda se colorearía <u>solo</u> porque había una coincidencia de TRI o QUAD?
</div>


<div>
this is an TRI<br><br>you have RANGE&nbsp;<br><br>1<br>6<br>4<br><br><br>then ORD have &nbsp;461 in number&nbsp; 4617<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563382/ex53.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563382/ex53.PNG" class="fr-fic fr-dib"></a>
</div>


<div>
Are you saying that to color the cells of column V I need to look in the ORDs for these? Did I miss any?<br />
1486<br />
148<br />
468<br />
81<br />
48<br />
46
</div>


<div>
Yes Sir !!<br><br>theses too can be&nbsp;<br>41 <br>61<br>86 <br><br>861 &nbsp; <br>461<br><br><br>
</div>


<div>
You never before indicated that we needed to also search for non-contiguous combinations.<br />
<br />
Nunca antes indicaste que necesitábamos buscar también combinaciones no contiguas.
</div>


<div>
well<br>you can always go deeper<br><br>the idea behind all this is to see practical results<br><br>We are working on that
</div>


<div>
we try to identify sequences in RANGE<br><br>that appear in ORD<br><br><br>in range we expect an order either down or up<br><br><br>but in ORD it is more flexible in ORD we hope that it appears in any order of the number in ORD<br><br><br>in RANGE it is a sequence up or down<br><br>that is in any position in ORD
</div>


<div>
Sorry but I don't understand that at all.
</div>


<div>
1- you have to look in Range first (left side only)<br>The sequence in RANGE can be UP or Down <br><br>2- the you compare it (the range sequence) to the ORD num<br>(ORD num can have the sequence in any order)
</div>


<div>
Week 4W2012 column AD winds up with all ten possible ranges. This will take a lot of work but please tell me all the 1st character combinations that I need to look for in 5W2012 and then tell me things like &quot;AD44 is colored red because xx matches yy in Cnnnn&quot; for each of the 10 ranges.<br />
<br />
La columna AD de la semana 4W2012 termina con los diez rangos posibles. Esto requerirá mucho trabajo, pero por favor dígame todas las combinaciones de 1er carácter que necesito buscar en 5W2012 y luego dígame cosas como &quot;AD44 es de color rojo porque xx coincide con yy en Cnnnn&quot; para cada uno de los 10 rangos.<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563395/2021-06-15_11-07-33.png" target="_blank" title="2021-06-15_11-07-33.png (333 KB)"><img alt="2021-06-15_11-07-33.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w25/800_1563395/2021-06-15_11-07-33.png" /></a>
</div>


2021-06-15_11-07-33.png

<div>
in column AD for next week i see<br><br>--------------------------------------<br>A-<br>----------------------------------------------<br>00<br>40<br>60 &nbsp; =TRI = &nbsp;460 in ORD (4609 ) &nbsp;is &nbsp;ligth red because is in he next week<br>---------------------------------------<br>B-<br>-------------------------------------<br>00<br>40 =PAIR &nbsp;UP = &nbsp;40 &nbsp;in ORD in 4039 &nbsp; is &nbsp;ligth red because is in he next week<br>-----------------------------------------<br>C-<br>--------------------------------------<br><br>40<br>60 = PAIR DOWN &nbsp;= 46 &nbsp;in ORD 4679 &nbsp;is &nbsp;ligth red because is in he next week<br><br>-----------------------------------------------------------------------------------------------------------<br><br>the first thing we see that appears is a TRI<br>then you only see 2 pairs of pairs<br><br>that by the way they already appear in the TRi<br><br>But I'm showing you how to watch the hits<br><br><br>Those are the sequences that are in RANGE and are identified in ORD<br><br>1-RANGE has the sequences<br><br>2- then those sequences are searched in ORD<br>so we see a hit per play<br><br>What we are seeing is from which area the numbers listed in RANGE that appear in ORD are coming out<br><br>
</div>


<div>
I don't believe you did as I asked.<br />

<blockquote>
please tell me all the 1st character combinations that I need to look for in 5W2012 and then tell me things like &quot;AD44 is colored red because xx matches yy in Cnnnn&quot; for each of the 10 ranges.
</blockquote>
</div>


<div>
<blockquote>please tell me all the 1st character combinations that I need to look for in 5W2012 and then tell me things like "AD44 is colored red because xx matches yy in Cnnnn" for each of the 10 ranges.</blockquote><br>sorry i get lost. provide an sample<br><br>but the first place to look in &nbsp;is in column AD &nbsp;i see many sequences<br>AD40 have an sequence with 046 ( this case donwload)<br><br>then i look ORD to identify the sequences that belong from RANGE<br><br>example the first &nbsp;sequence (not ONLY digit I match is 0 4 6 &nbsp;because it appear in ORD<br><br>so my first place to see as RANGE sequences in this case SAT PM<br><br>then i move to ORD to see what ORD have to in that sequence
</div>


<div>
you can begins &nbsp;to see the sequences from &nbsp;RANGE from AD44 down then compare to ORD by each number<br><br>&nbsp;if I understood the question of where to start
</div>


<div>
As <a href="https://www.experts-exchange.com/questions/29218073/4N-Count-by-week.html?anchorAnswerId=43302222#a43302222" rel="ugc">i did here</a> in 4W2012 I need to know every 1st character range combination in column AD that I need to look for in 5W2012.<br />
<br />
I also need to know which ranges in column AD would become red, and if so the 1st character range combination and ORD that caused it.<br />
<br />
Como hice aquí en 4W2012, necesito saber cada combinación de rango de 1er carácter en la columna AD que necesito buscar en 5W2012.<br />
<br />
También necesito saber qué rangos en la columna AD se volverían rojos y, de ser así, la combinación del primer rango de caracteres y el ORD que lo causó.
</div>


<div>
if&nbsp; I am understanding well<br><br>start from top to bottom in the column you are going to work on<br><br>in this case the column AD SAT PM&nbsp; RANGE<br><br>9<br>3<br>5<br>7<br>0<br>4<br>6<br>8<br>2<br>1<br><br>top to bottom checking sequences<br><br><br>93 &nbsp;appears 2 times in num &nbsp;4039 &nbsp; and 2039 &nbsp;in the next week35<br><br>&nbsp; &nbsp; &nbsp; then next sequence<br><br>35 not sequence in ord<br><br>&nbsp; &nbsp; &nbsp;then next sequence is 57<br><br>57 &nbsp; = it appears in &nbsp;4579 in ORD<br><br>&nbsp; &nbsp; then next sequence<br><br>70 &nbsp;not sequence in ord<br><br>&nbsp; &nbsp; &nbsp;then<br><br>04 = it appears in <u>4609&nbsp;</u>and &nbsp;4039 &nbsp;and &nbsp;in ORD<br><br>&nbsp; &nbsp; &nbsp;then<br><br>46 = it shows in <u>4679</u> and 4609 &nbsp;in ORD notice 2 pairs in sequence means an TRI as this is an TRI Number<br><br>&nbsp; &nbsp; &nbsp;then<br><br>68 &nbsp;= &nbsp;not sequence in ord &nbsp;for this sequence<br><br><br>82 = &nbsp;not sequence in ord &nbsp;for this sequence<br><br>21 = not sequence in ord &nbsp;for this sequence<br><br><br>1-Moving down the RANGES Column (left value) we see the pairs that come out in ORD if these are cotinuas they have a TRI or a QUA<br><br><br><br><br><br><br><br>
</div>


<div>
<blockquote>Why didn't you look for 07 or 39?&nbsp;</blockquote><br>i say 93 because that the order from up to down but is 39 in &nbsp;ORD &nbsp;but i mention it<br>(just try &nbsp;to shows how i take the pairs ) &nbsp;but you rigth should be as ORD<br><br><br>"93 &nbsp;appears 2 times in num &nbsp;4039 &nbsp; and 2039 &nbsp;in the next week35"<br><br>&nbsp; &nbsp; &nbsp; then next sequence<br><br><br>but will be an best way see the &nbsp;RANGE from up to down like ORD so will be more easy to match<br><br><br>07 is not in RANGE Sequence<br><br><br>07 is not in sequence from top to bottom<br><br>I look at the sequences in order from top to bottom<br><br>
</div>


<div>
In 4W2012, column T winds up with just two ranges: 90 and 00. When I look for pairs forward in 5W2012, 90 gets colored because 09 is in cell C45 and 90 is the <u>first range from the top</u>. When I go backward I still look for 90 and still get a match in C45, but in this case do I color '00' because it's the <u>first range from the bottom</u>?<br />
<br />
En 4W2012, la columna T termina con solo dos rangos: 90 y 00. Cuando busco pares hacia adelante en 5W2012, 90 se colorea porque 09 está en la celda C45 y 90 es el <u>primer rango desde la parte superior.</u> Cuando retrocedo, sigo buscando 90 y aún obtengo una coincidencia en C45, pero en este caso, ¿coloreo '00' porque es el <u>primer rango desde abajo</u>?
</div>


<div>
i&nbsp; see&nbsp;<br><br>when we talk about T44 and &nbsp;T45 &nbsp;we have 90 in range (09 to ORD and 00 to ORD)<br>we have<br><br>90<br>00<br><br>we only have here (the left side to work with)<br><br>9<br>0 &nbsp; &nbsp; so we look for 09 in any ORD number as an PAIR (pair is the basic unit in tihis situation)<br><br>90<br>00 &nbsp;is not an pair for us in this situation &nbsp;i means (90 or 00&nbsp; alone are not useful for us)<br><br><br>
</div>


<div>
This is so frustrating. When you said &quot;up and down&quot; I assumed that in the case of column T in 1W2012 that I should look first down from the top of the ranges so I'd <br />
look for the ordered arrangement of 1 and 6 (61) and get a match with C27. I would then color 10.<br />
look for the ordered arrangement of 6 and 4 (46) and get a match with C27. &nbsp;I would then color 60.<br />
That's as far as I can look down so I assumed I would have to look up from the bottom of the ranges and<br />
<u>look for the ordered arrangement of 4 and 6 (46) and get a match with C27. &nbsp;I would then color 40.</u><br />
<br />
If the underlined step isn't correct then how can 40 get colored?????
</div>


<div>
1- do not get frustrated<br><br>2-"When you said "up and down" I assumed that in the case of column T in 1W2012 that I should look first down from the top of the ranges so I'd "<br><br>ok always do .just move down only &nbsp;that's<br><br>remember<br><br>when we have an range<br>you have<br><br>example column T<br>( you see this )<br><br><br>10<br>60<br>40<br><br>(but works like this)<br>this equals to<br><br>1<br>6<br>4<br><br>you then look for the pair 16 for that week (and is present)<br><br>you then you goes to the next &nbsp;to see &nbsp;64 &nbsp;(and is present) <br><br>as you find the 2 near each other that is an TRI<br><br>so you have the 2 pais with colors making an TRI<br><br><br>you're doing super good keep looking down<br><br>and the couples that arise from below are fine<br><br>do not look up because they are already identified<br><br><br>(I might try to explain up and down to you<br>when we were talking about a range in the middle of the column<br>but with the pattern you are doing from top to bottom you can create all the necessary pairs)<br><br>you already have it !<br><br>&nbsp;<br><br><br><br><br><br>&nbsp;<br><br><br><br><br><br>3-<br><br>
</div>


<div>
One more question about coloring the cells. In my code when I find a match I always color just the first range. For example when I find a match for 61 I color the 10 because that's the first range of the pair, and when I find a match for 46 I color the 60 because that's the first range of the pair. Is that the correct thing to do?
</div>


<div>
I'm sorry if we've &nbsp;talked about this before but assume there there 4 ranges in a column:<br />
10<br />
20<br />
30<br />
40<br />
<br />
When I look for pairs I currently look for <br />
the ordered value of 12 = 21<br />
the ordered value of 23 = 23<br />
the ordered value of 34 = 43<br />
<br />
Did I miss any?<br />
<br />
When I look for triples I currently look for <br />
the ordered value of 123 = 213<br />
the ordered value of 234 = 423<br />
<br />
Did I miss any?
</div>


<div>
When I look for pairs I currently look for<br>the ordered value of 12 = 21<br>the ordered value of 23 = 23<br>the ordered value of 34 = 43<br><br><blockquote>Did I miss any?&nbsp;</blockquote>Not<br><br>When I look for triples I currently look for<br>the ordered value of 123 = 213<br>the ordered value of 234 = 423<br><br>Did I miss any? <br><br>Not<br><br>
</div>


<div>
Then why is V8 colored in your picture?
</div>


<div>
please give more information <br><br>as possible Please
</div>


<div>
<a href="https://www.experts-exchange.com/questions/29218073/4N-Count-by-week.html?anchorAnswerId=43302220#a43302220" rel="ugc">In this picture</a> you show V8 (60) colored and I don't see any pair or tri match for that cell.
</div>


<div>
here best expert!<br><br>&nbsp;<br>It is repeated because the couple that comes out is 46<br><br>but&nbsp; It was already marked in column T7<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563474/ex51.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563474/ex51.PNG" class="fr-fic fr-dii"></a><br><br><br><br><br><br>
</div>


<div>
In some cases I'm coloring the wrong ranges and I'm having trouble figuring out a foolproof way of doing it. Here are a couple of examples in 1W2012 column T.<br />
Currently when I find a match for a pair I always color the first range in the pair. So for example when I find a match for 61 I color the 10 because it's the first range in the pair. Please let me know if you think that that is the way to do it. &nbsp;However when I find a match for the 461 tri I want to color the 40 but that's not the first range. What rule would tell me to color 40?<br />
<br />
En algunos casos, estoy coloreando los rangos incorrectos y tengo problemas para encontrar una forma infalible de hacerlo. Aquí hay un par de ejemplos en la columna T del 1W2012.<br />
Actualmente, cuando encuentro una coincidencia para un par, siempre coloreo el primer rango del par. Entonces, por ejemplo, cuando encuentro una coincidencia para 61, coloreo el 10 porque es el primer rango del par. Por favor, avíseme si cree que esa es la forma de hacerlo. Sin embargo, cuando encuentro una coincidencia para el 461 tri, quiero colorear el 40, pero ese no es el primer rango. ¿Qué regla me diría que coloreara 40?
</div>


<div>
go to the Pairs and leave the TRi aside<br>I would tell you Martin to observe this rule<br>I explain to you<br><br>1-when there is a TRI there are two consecutive pairs<br>therefore it is a tri marked by two consecutive pairs<br><br>2-when there is a there are three consecutive pairs<br>therefore it is a QUA marked by three consecutive pairs<br><br>When I say consecutive I mean Sequence which is what we are identifying<br><br><br>If this is so, you should not look for TRI or Qua<br><br>because they are going to be consecutive pairs<br><br>Maybe something that we should try to identify is when a PAIR or a Couple is repeated on more than one occasion because that is another indicator that it is there in that area taking the ORDs<br>(I mean where is the next number going to be from)<br><br>
</div>


<div>
Do you think this would work? In column T there are three ranges and I currently look for just two pairs: 10 and 60 (61) and 60 and 40 (46). 10 gets colored from the the 61 and 60 get colored from 46. When there are an odd number of ranges I could do one &quot;up&quot; match starting with the last range which would be 40 and 60 (46) which matches just like it did previously but in this case I would color the last range rather than the first. <br />
<br />
¿Crees que esto funcionaría? En la columna T hay tres rangos y actualmente busco solo dos pares: 10 y 60 (61) y 60 y 40 (46). 10 se colorea desde el 61 y 60 se colorea desde el 46. Cuando hay un número impar de rangos, podría hacer una coincidencia &quot;ascendente&quot; comenzando con el último rango, que sería 40 y 60 (46), que coincide exactamente como lo hizo. anteriormente, pero en este caso colorearía el último rango en lugar del primero.
</div>


<div>
Or simpler. If there's an odd number of ranges and the next to the last one is colored then the last one also gets colored.<br />
<br />
O más simple. Si hay un número impar de rangos y el siguiente al último está coloreado, el último también se colorea.
</div>


<div>
ok<br><br>Are you seeing that this is repeated?<br><br>in others weeks situations ??<br><br><br><br><br><br>
</div>


<div>
Do you agree with these?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563514/2021-06-16_13-50-43.png" target="_blank" title="2021-06-16_13-50-43.png (345 KB)"><img alt="2021-06-16_13-50-43.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2021/06_w25/800_1563514/2021-06-16_13-50-43.png" /></a>
</div>


2021-06-16_13-50-43.png

<div>
Great now remind me of something else. When I compare the current week's pairs with the current week's ORDs do I start at the ORD that's after the current pair? In other words for 26W2013 column S do I start looking with ORD 2619?<br />
<br />
Genial ahora me recuerdan a otra cosa. Cuando comparo los pares de la semana actual con los ORD de la semana actual, ¿empiezo en el ORD que sigue al par actual? En otras palabras, para la columna S del 26W2013, ¿empiezo a buscar con ORD 2619?
</div>


<div>
Going back to Week Top Num for a minute, do you need the light green background color like in G5?
</div>


<div>
<blockquote>do you need the light green background color like in G5?</blockquote><br><br>Yes.<br>I prefer it because it helps me
</div>


<div>
in something if I need a help<br><br>for example<br><br>every time I used the Plays in BYPLAY sheet button<br><br>the marks that I do are erased<br><br>that is, I manually color some values in WEEK TOP NUM<br><br>and they are erased, can you help me not to erase them?
</div>


<div>
I already have a version that changes what Plays does. In the new version it only copies the data from Sheet1 and does not clear anything.
</div>


<div>
Thank you !!&nbsp; ;)<br><br>that way I can manually color what I need and it will not be erased
</div>


<div>
the same can be with BYYEARS sheet ?
</div>


<div>
In a new question I can probably do anything you want.
</div>


29218073a.xlsb

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


<div>
Best Expert !<br><br>can you &nbsp;fixed the black fill in the &nbsp;Range <br><br>i can't see the numbres&nbsp;
</div>


<div>
as shows<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563643/ex54.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w25/1563643/ex54.PNG" class="fr-fic fr-dib"></a>
</div>


ex54.PNG

29218073b.xlsb

<div>
<div class="content wysiwyg-content fr-view">
4N wDD wGTWK<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w24/1563120/29217947c.xlsb" rel="ugc">29217947c.xlsb</a><br><br>1- count Range by DAY INcrement by WEEk<br><br>&nbsp; a-Begings in MON AM then add MON PM then add TUE AM then ADD TUE PM<br>then ADD WED AM then ADD WED PM until finish the week &nbsp;SAT PM<br><br>as shows <a href="https://filedb.experts-exchange.com/incoming/2021/06_w24/1563121/ex35.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w24/1563121/ex35.PNG" class="fr-fic fr-dib"></a><br>
</div>
</div>


ex35.PNG

29217947c.xlsb


4N wDD wGTWK
29217947c.xlsb
1- count Range by DAY INcrement by WEEk
  a-Begings in MON AM then add MON PM then add TUE AM then ADD TUE PM
then ADD WED AM then ADD WED PM until finish the week  SAT PM
as shows

4N Count  by week

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.