ADRIANA P
asked on
4n count by sections TP
4N wmanual colors to add Top PAIRS
29218692.xlsb
1- in BYPLAY sheet count by each DAY the TOP PAIR and shows in PAIRS TOP
29218692.xlsb
1- in BYPLAY sheet count by each DAY the TOP PAIR and shows in PAIRS TOP
I'm sorry but I don't have any idea what you are trying to tell me in those pictures and I also don't know what "can you do 2" means.
Lo siento, pero no tengo ni idea de lo que estás tratando de decirme en esas fotos y tampoco sé qué significa "can you do 2".
Lo siento, pero no tengo ni idea de lo que estás tratando de decirme en esas fotos y tampoco sé qué significa "can you do 2".
ASKER
ok
i shows how to goes day by day and how have to be work to get the TOP PAIR as needed in BYPLAY sheet
beging (start) 1- day1 = 2579 then count
add 2-day 2 = 2201 then count
add 3-day 3 = 1157 then count
add 4-day 4 = 1357 then count
add 5-day 5 = 2819 then count
add 6-day 6 = 2199 end
that's i shows how to goes day by day then how have to be shows in the PAIR TOP
i shows how to goes day by day and how have to be work to get the TOP PAIR as needed in BYPLAY sheet
beging (start) 1- day1 = 2579 then count
add 2-day 2 = 2201 then count
add 3-day 3 = 1157 then count
add 4-day 4 = 1357 then count
add 5-day 5 = 2819 then count
add 6-day 6 = 2199 end
that's i shows how to goes day by day then how have to be shows in the PAIR TOP
please forget about "can you do 2" not te be done
For 26W2013, please show me what MON to WED should look like.
Para el 26W2013, muéstrame cómo debería ser de lunes a miércoles.
Para el 26W2013, muéstrame cómo debería ser de lunes a miércoles.
ASKER
For 26W2013, please show me what MON to WED should look like.
ASKER
Where? In your picture BYPLAY 26W2013 is empty!
ASKER
well it's because rigth now it begings couting pairs after 3 hits or more
Is it true that MON, TUE and WED will always be blank fot PAIR TOP?
I see that the numbers that you put in BYPLAY PAIR TOP for THU AM are the Sheet1 PAIR TOP counts. What goes in BYPLAY PAIR TOP for THU PM?
At some point in the future are you planning on deleting Sheet1? I ask because if you are then I can't simply copy the PAIR TOP counts from Sheet1 because some day they will be gone and so I need to calculate them instead.
¿Es cierto que MON, TUE y WED siempre estarán en blanco para PAIR TOP?
Veo que los números que pones en BYPLAY PAIR TOP para el jueves son los recuentos de Sheet1 PAIR TOP. ¿Qué incluye BYPLAY PAIR TOP para los jueves?
En algún momento en el futuro, ¿planea eliminar Sheet1? Lo pregunto porque si es así, entonces no puedo simplemente copiar los recuentos de PARES SUPERIORES de la Hoja1 porque algún día desaparecerán y entonces necesito calcularlos.
I see that the numbers that you put in BYPLAY PAIR TOP for THU AM are the Sheet1 PAIR TOP counts. What goes in BYPLAY PAIR TOP for THU PM?
At some point in the future are you planning on deleting Sheet1? I ask because if you are then I can't simply copy the PAIR TOP counts from Sheet1 because some day they will be gone and so I need to calculate them instead.
¿Es cierto que MON, TUE y WED siempre estarán en blanco para PAIR TOP?
Veo que los números que pones en BYPLAY PAIR TOP para el jueves son los recuentos de Sheet1 PAIR TOP. ¿Qué incluye BYPLAY PAIR TOP para los jueves?
En algún momento en el futuro, ¿planea eliminar Sheet1? Lo pregunto porque si es así, entonces no puedo simplemente copiar los recuentos de PARES SUPERIORES de la Hoja1 porque algún día desaparecerán y entonces necesito calcularlos.
ASKER
Is it true that MON, TUE and WED will always be blank fot PAIR TOP?
yes !
because the pairs to be account for are 3 or more pairs repeated same week1 (hits by week)
What goes in BYPLAY PAIR TOP for THU PM?
as shows
i have one question you see here 61 hit 4 times
then 26 hit 3 times
then 21 hit 3 times
i want to get the count for it to shows the TOP PAIRS
Does it make any difference in the count ??? 4 times hits 3 times hits ??
At some point in the future are you planning on deleting Sheet1?
I can't delete the data from sheet 1
in no time if I will add years to come
To compute the PAIRS TOP it is important to do with your own counter and start with MON AM then count then ADD MON PM
in increments of each occurrence because in this example they begin to be counted on Thursdays but there are other weeks that begin to appear earlier depending on how they are running
I don't have any idea what you want me to do.
ASKER
This question is to create a counter that counts the couples that are repeated per week as I showed with the photos and the explanation
The pictures you show here really confuse me.
- Why are the cells in BF pointing to 21 under PAIR?
- Why is 21 pointing to TRIPLE TOP column DK
- Why are BYPLAY PAIR THU AM and PM columns the same?
ASKER
- Why are the cells in BF pointing to 21 under PAIR?
I'm only showing or pointing out the pairs starting with pair 21 down
2-
- Why is 21 pointing to TRIPLE TOP column DK
you are right this show is wrong
and I correct it should point to the DR column
as shows
3- Why are BYPLAY PAIR THU AM and PM columns the same?
in that you are also right there are no changes
because no more couples have emerged in the count
every time a number is added it is counted and added when there are new pairs
because no more couples have emerged in the countAre you expecting me to recalculate the data in Sheet1's PAIR TOP as a part of calculating BYPLAYS' PAIR TOP?
ASKER
I need the routine to be done as I explain it
otherwise I would not be making this section effective
it must be like that
I understand that you should not use sheet 1 but do like this the counter for TOP PAIRS
26W2013
START MON AM = 2839 then count TOP PAIRS then
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then ....
otherwise I would not be making this section effective
it must be like that
I understand that you should not use sheet 1 but do like this the counter for TOP PAIRS
26W2013
START MON AM = 2839 then count TOP PAIRS then
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then ....
I understand that you should not use sheet 1Then why do you show sheet 1 in your pictures????????
START MON AM = 2839 then count TOP PAIRS thenI don't know what that means.
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then .
ASKER
You're right I'm trying to explain as best as possible and maybe that confuses you
in this case I am trying to show everything I have to do to achieve the desired result and those are the details that I do that are tedious
Maybe I shouldn't have done it like that because it causes you confusion but I thought that explaining all the detail would help to understand what to do
in this case I am trying to show everything I have to do to achieve the desired result and those are the details that I do that are tedious
Maybe I shouldn't have done it like that because it causes you confusion but I thought that explaining all the detail would help to understand what to do
You say "START MON AM = 2839 then count TOP PAIRS...". What does that mean exactly and what is the result when I do?
You then says "...then ADD MON PM = 2619 then count TOP PAIRS".What does that mean exactly and what is the result when I do?
You then says "...then ADD MON PM = 2619 then count TOP PAIRS".What does that mean exactly and what is the result when I do?
ASKER
every week starts on monday AM in this week
is 26W2013
every week starts on monday
every time an occurrence happens, I count adding to the previous occurrences
26W2013
START MON AM = 2839 then count TOP PAIRS then l
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then ....
until the last occurrence SAT PM
is 26W2013
every week starts on monday
every time an occurrence happens, I count adding to the previous occurrences
26W2013
START MON AM = 2839 then count TOP PAIRS then l
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then ....
until the last occurrence SAT PM
You didn't answer my question.
ASKER
I am answering as I understand it
You can show the question with an example and options
many times you says you does not understand but does not give explanations of what you does not understand or where you stopped understanding
I have repeatedly explained the same
i did with steps which step you say you get lost
you never goes by the steps i do
You can show the question with an example and options
many times you says you does not understand but does not give explanations of what you does not understand or where you stopped understanding
I have repeatedly explained the same
i did with steps which step you say you get lost
you never goes by the steps i do
In 26W2013 the first ORD is 2839. What do I do with 2839?
ASKER
it is the beginning
where it begins to be counted
What do you not understand about that?
and explain if possible with examples
I'm answering, I still understand the question
If you don't ask me the question clearly, I won't understand
where it begins to be counted
What do you not understand about that?
and explain if possible with examples
I'm answering, I still understand the question
If you don't ask me the question clearly, I won't understand
it is the beginningWhat is counted?
where it begins to be counted
What is the result of the counting?
What do I do with the result?
¿Qué se cuenta?
¿Cuál es el resultado del conteo?
¿Qué hago con el resultado?
ASKER
we are counting the pairs cumulatively from taking into account as they arise
the TOP PAIRS button counts the pairs
that are identified in column BX by weeks (SETS)
It is an example of what I want to achieve
in this case from the first occurrence I wish
count the pairs that are repeated
therefore you have to convert the number 2839
couples to be counted
2839 = 28 83 39 23 29
the TOP PAIRS button counts the pairs
that are identified in column BX by weeks (SETS)
It is an example of what I want to achieve
in this case from the first occurrence I wish
count the pairs that are repeated
therefore you have to convert the number 2839
couples to be counted
2839 = 28 83 39 23 29
Yes I understand that the the four pairs in 2839 are 28 83 39 23 29, but what do I do with them?
ASKER
then each number has to be converted to pairs
that will be counted cumulatively
2839 = 28 83 39 23 29
2619 = 26 61 19 21 29
8579 = 85 57 79 87 89
2245 = 22 24 25
2611 = 26 21
6635 = 66 63 35
in this example: 26 appears 2 times
29 appears twice
21 appears 2 times
89 appears 2 times
In this solution, what we are doing, I need to identify the pairs that appear more than 3 times and all those that appear more than 3 times.
that are identified then the digits of those pairs are counted to know the order from highest to lowest
and see it in a column by DAY of an week
that will be counted cumulatively
2839 = 28 83 39 23 29
2619 = 26 61 19 21 29
8579 = 85 57 79 87 89
2245 = 22 24 25
2611 = 26 21
6635 = 66 63 35
in this example: 26 appears 2 times
29 appears twice
21 appears 2 times
89 appears 2 times
In this solution, what we are doing, I need to identify the pairs that appear more than 3 times and all those that appear more than 3 times.
that are identified then the digits of those pairs are counted to know the order from highest to lowest
and see it in a column by DAY of an week
I know that I said that the pairs in 2839 are 28 83 39 23 29 but why isn't 89 a pair?
ASKER
my mistake
Please identify all possible pairs of the number in ORD and count them
Please identify all possible pairs of the number in ORD and count them
ASKER
I know I said 3 but I could be 2 or more the repetition of the pairs?
ASKER
or may be have the option to select 3 or 2 as needed?
I need to identify the pairs that appear more than 3 times and all those that appear more than 3 times.Did you mean to say "I need to identify the pairs that occur 3 or more times"?
In any case when I look at 23W2013 and I get to SAT PM I find that
21 occurs 3 times
26 occurs 3 times
57 occurs 3 times
61 occurs 4 times
What do I do with that information?
I didn't see your previous two comments when I added this comment.
ASKER
Did you mean to say "I need to identify the pairs that occur 3 or more times"?
yes!
What do I do with that information?
I need to count each digit
the times that are repeated
61
61
61
61
57
57
57
26
26
26
21
21
21
= 6 = 7 times
1 = 7 times
2 = 6
7 = 3
5 = 3
this is the correct way to tell
this is what should appear in the SAT PM PAIRS TOP column
6
1
2
7
5
9
8
4
3
0
yes!
What do I do with that information?
I need to count each digit
the times that are repeated
61
61
61
61
57
57
57
26
26
26
21
21
21
= 6 = 7 times
1 = 7 times
2 = 6
7 = 3
5 = 3
this is the correct way to tell
this is what should appear in the SAT PM PAIRS TOP column
6
1
2
7
5
9
8
4
3
0
ASKER
I am asking that although I asked to count only the pairs that are repeated more than 3 times
If I can have an option to choose between 2 and 3 as needed?
If I can have an option to choose between 2 and 3 as needed?
FYI, I'm still working on this but have been busy in my garden.
ASKER
glad to know that the garden is well taken care of
moments of relaxation bring us peace and are the source of our inspiration ...
moments of relaxation bring us peace and are the source of our inspiration ...
Yay! I have Top Pair SAT PM working.
BTW, my garden is almost 500 square meters so there's a lot of work:)
BTW, my garden is almost 500 square meters so there's a lot of work:)
ASKER
I see that the garden recharges you with energy and success
Please !!
never give it up ;)
Please !!
never give it up ;)
ASKER
and I think that with 500 meters you have an adequate dose of Inspiration and Blessings!
I hope you think like me! :)
I hope you think like me! :)
Well at 80 it's harder than it used to be but as long as I have two good legs under me I'll keep doing it.
ASKER
Touching the ground is a way of electrical discharge of your nervous system and if you do it while sunbathing for at least 10 minutes it is very healthy to relax and it should be done at least 3 times in weeks that also activates your defense system
but not only that breathing and letting life flow is an invitation to Health we are that Nature of God we are his creation
sowing is a way to give life to life I love it and see how they grow and become beautiful !!
but not only that breathing and letting life flow is an invitation to Health we are that Nature of God we are his creation
sowing is a way to give life to life I love it and see how they grow and become beautiful !!
For week 26W2013 it seems that for SAT PM I look for pairs in all the ORDS in rows 1006 to 1017. What rows do I look at for SAT AM?
Para la semana 26W2013 parece que para SAT PM busco pares en todos los ORDS en las filas 1006 a 1017. ¿Qué filas miro para SAT AM?
Para la semana 26W2013 parece que para SAT PM busco pares en todos los ORDS en las filas 1006 a 1017. ¿Qué filas miro para SAT AM?
ASKER
26W2013
SAT AM will be from rows 1006 to 1016 ORD
SAT AM will be from rows 1006 to 1016 ORD
Is this is correct? Please stop testing after the first error and tell me what is wrong.
¿Es esto correcto? Deje de probar después del primer error y dígame cuál es el problema.
i also have a couple of other questions.
Look at 2W2012. For THU AM there is only one pair that occurs 3 or more times and that is 89. So are 8 and 9 the only numbers that I count and put in the Top pair column? There are two additional pairs that occur two times, 87 and 79. Should I also count the 7's?
What do I do if there are no pairs in THU AM (or any other column) that occur 3 or more times? Do I leave the column blank?
También tengo un par de preguntas más.
Mire 2W2012. Para los JUEVES, solo hay un par que ocurre 3 o más veces y es 89. Entonces, ¿son 8 y 9 los únicos números que cuento y coloco en la columna del par superior? Hay dos pares adicionales que ocurren dos veces, 87 y 79. ¿Debería contar también los 7?
¿Qué hago si no hay pares en THU AM (o en cualquier otra columna) que ocurran 3 o más veces? ¿Dejo la columna en blanco?
¿Es esto correcto? Deje de probar después del primer error y dígame cuál es el problema.
i also have a couple of other questions.
Look at 2W2012. For THU AM there is only one pair that occurs 3 or more times and that is 89. So are 8 and 9 the only numbers that I count and put in the Top pair column? There are two additional pairs that occur two times, 87 and 79. Should I also count the 7's?
What do I do if there are no pairs in THU AM (or any other column) that occur 3 or more times? Do I leave the column blank?
También tengo un par de preguntas más.
Mire 2W2012. Para los JUEVES, solo hay un par que ocurre 3 o más veces y es 89. Entonces, ¿son 8 y 9 los únicos números que cuento y coloco en la columna del par superior? Hay dos pares adicionales que ocurren dos veces, 87 y 79. ¿Debería contar también los 7?
¿Qué hago si no hay pares en THU AM (o en cualquier otra columna) que ocurran 3 o más veces? ¿Dejo la columna en blanco?
ASKER
are you posting an file?
I wasn't planning on it. You have the ORDs in previous workbooks so I don't think you need one to answer my questions.
ASKER
can i shows 26W2013 with pic so it help you??
Sure.
ASKER
Is this is correct? Please stop testing after the first error and tell me what is wrong.
I ask you if you put any file why do you say try
ASKER
ok i will put the pic for step by step
I ask you if you put any file why do you say tryI don't understand what that means,
ASKER
I wonder if you meant to say that it will test some file?
All I was asking you to do was to look at the picture and tell me if anything is wrong. I've done that in other questions and you didn't seem to have a problem with me doing that.
Todo lo que te pedía que hicieras era que miraras la foto y me dijeras si algo andaba mal. Lo he hecho en otras preguntas y no parece que tengas ningún problema en que lo haga.
Todo lo que te pedía que hicieras era que miraras la foto y me dijeras si algo andaba mal. Lo he hecho en otras preguntas y no parece que tengas ningún problema en que lo haga.
ASKER
ok I see
is not problem to me is an good way
im working doing the 26W2013 full so we check it
but give me an chance to upload it
is not problem to me is an good way
im working doing the 26W2013 full so we check it
but give me an chance to upload it
ASKER
1-BEGINING MON AM
Why are you showing me Sheet1? Please don't. Just look at the picture I posted and tell me what is wrong if anything and also please answer my two questions.
ASKER
2- now will be MON AM + MON PM ( you count the pairs from mon am +mon PM ) wil
STOP!
ASKER
What do I do if there are no pairs in THU AM (or any other column) that occur 3 or more times? Do I leave the column blank?i need to say
can we have the option to select count 2 or more
or 3 or more pairs ??? i just asking to see is we can have an option for it??
Why is SAT AM empty?
i just asking to see is we can have an option for it??Yes, sure, but let's figure out 3 first.
ASKER
Why is SAT AM empty?
it is empty because there is no change
that is, I need to see the changes
need to see the changesOkay that's not hard to do but why didn't you tell me sooner?
ASKER
my mistake
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great Job !
Best Expert !
Best Expert !
ASKER
If this is correct I will add the option to look for pairs occurring two or more times
new question for ??
Not necessary.
ASKER
:)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
have an situation when i try to update it don't
thats is in all the update you did
thats is in all the update you did
What are you trying to update?
ASKER
i try it in all where you put it
but for example Summary and BYYEARS
but for example Summary and BYYEARS
ASKER
it erasse my manuals marks or colors i put manually
For Summary please describe exactly what you did.
Para Summary, describa exactamente lo que hizo.
Para Summary, describa exactamente lo que hizo.
ASKER
in Summary
1- in sheet1 (After i have new data in ) hit summary then hit replace
then nothings happens
1- in sheet1 (After i have new data in ) hit summary then hit replace
then nothings happens
Please attach the workbook that has the new data.
ASKER
you can use the last book we did here
just cut all the ord you want to test and replace
then run summary
then add the cuts ord back and this time try replace
because you just want add the news ones
just cut all the ord you want to test and replace
then run summary
then add the cuts ord back and this time try replace
because you just want add the news ones
No, I need the workbook that didn't work.
ASKER
that's the workbook im talking about
but to test you have to take data from or out (cut) then run the replace button
then add back so you can see is not working
but to test you have to take data from or out (cut) then run the replace button
then add back so you can see is not working
When the Summary button is clicked on Sheet1 and then you choose 'Replace', the first thing that happens is that all the data on the Summary sheet is deleted. Then the data for all the Summary columns are copied from Sheet1 to the Summary sheet.
ASKER
ok thats working great
the problem belong when add data i just add one day then all i want is update not replace
1- i dont update
2- need dont loose the manuals color i did ( formats)
the problem belong when add data i just add one day then all i want is update not replace
1- i dont update
2- need dont loose the manuals color i did ( formats)
ASKER
yo can test it
taking out some data
later add back using update button
then you will see
taking out some data
later add back using update button
then you will see
- On the Summary sheet I made row 10 all yellow
- I then deleted week 52W2013 from Sheet1
- Then I clicked the Summary button and chose Update
- Row 10 stayed yellow
- I put week 52W2013 back
- clicked the Summary button and chose Update
- Row 10 stayed yellow
ASKER
ok i agree with you stay yellow but don't update the data as needed
To be useful summary have to add in one place ORD, PAIRS TOP, RANGE, TRI TOP, ect..
and it doesn do it
but it dont add the new ord nums or news pair Top , Range, Tri, ect..
example
1-take all data (ORD )from week 19W2021 down and cut it
2- paste in a blank sheet to clean all week from 21W2021down
3- now run all the buttons ( pair Top , Range, Tri, ect...) so summary will update
4- now get back week 19W2021 to 21w2021 and press all the buttons ( pair Top , Range, Tri, ect...)
5- now press summary then update
it don't change the colors rigth but it don't put the new numbers (ORD ) or the new pair Top , Range, Tri, ect... calculations
so even it don't erase the colors but to add new data to summary the only way is Replace button
update button don't add newdata as needed to summary
so the only way to add new data as needed to summary will erase the manually enters
To be useful summary have to add in one place ORD, PAIRS TOP, RANGE, TRI TOP, ect..
and it doesn do it
but it dont add the new ord nums or news pair Top , Range, Tri, ect..
example
1-take all data (ORD )from week 19W2021 down and cut it
2- paste in a blank sheet to clean all week from 21W2021down
3- now run all the buttons ( pair Top , Range, Tri, ect...) so summary will update
4- now get back week 19W2021 to 21w2021 and press all the buttons ( pair Top , Range, Tri, ect...)
5- now press summary then update
it don't change the colors rigth but it don't put the new numbers (ORD ) or the new pair Top , Range, Tri, ect... calculations
so even it don't erase the colors but to add new data to summary the only way is Replace button
update button don't add newdata as needed to summary
so the only way to add new data as needed to summary will erase the manually enters
I assume that "Update" means to add new data like a new year's data. What does it mean to you?
Supongo que "Update" significa agregar nuevos datos como los datos de un año nuevo. ¿Qué significa para ti?
Supongo que "Update" significa agregar nuevos datos como los datos de un año nuevo. ¿Qué significa para ti?
ASKER
wells i add data (ORD) daily as needed
that that way to analize the track (AM /PM by day)
1- usually when i begins ( after you finish an solution ) i put the data then an replace is mandatory to havde all the data ON
2- then as days are running i need to update ( that is by day, am /pm ) because need to analyze as ruuning the days
"Update" by years don't help me to see the daily track as needed
that that way to analize the track (AM /PM by day)
1- usually when i begins ( after you finish an solution ) i put the data then an replace is mandatory to havde all the data ON
2- then as days are running i need to update ( that is by day, am /pm ) because need to analyze as ruuning the days
"Update" by years don't help me to see the daily track as needed
I don't understand what you want "Update" to do. Perhaps if you used Google Translate I would understand you better.
No entiendo qué quieres que haga la "Update". Quizás si usaras Google Translate te entendería mejor.
No entiendo qué quieres que haga la "Update". Quizás si usaras Google Translate te entendería mejor.
ASKER
well!! I add data (ORD) daily
since that way I can analyze ORD (AM / PM by day)
1- I usually start when we finish a solution replacing the entire data. (When replacing all the DATA using the replace button helps me at that moment)
2-But once the data (ORD) is already set and as the days go by, I need to update (that is, per day, am / pm) because I need to analyze how (ORD) is developed in that monment I need the UPDATE button (q be it from day to day AM / PM)
"Refresh" for years does not help me to see the daily tracking as I need to see it
you can add the update button per day instead of per year
since that way I can analyze ORD (AM / PM by day)
1- I usually start when we finish a solution replacing the entire data. (When replacing all the DATA using the replace button helps me at that moment)
2-But once the data (ORD) is already set and as the days go by, I need to update (that is, per day, am / pm) because I need to analyze how (ORD) is developed in that monment I need the UPDATE button (q be it from day to day AM / PM)
"Refresh" for years does not help me to see the daily tracking as I need to see it
you can add the update button per day instead of per year
I believe the problem is that the Update process looks for new data in Sheet1 column 'B' rather than in Sheet1 column 'BF'. I'll change that.
ASKER
I have the same problem with all update
1- I need to add marks manually that are not deleted
2-That allows you to add the data that you added new (after having given replace once) and that does not appear
that is, once I press the replace button, then I only want to give updates to be able to preserve the brands and information that I have analyzed
otherwise I lose it if I can only update the data using replace button
that is, I only need to do replace once, then it will be updates all the time
1- I need to add marks manually that are not deleted
2-That allows you to add the data that you added new (after having given replace once) and that does not appear
that is, once I press the replace button, then I only want to give updates to be able to preserve the brands and information that I have analyzed
otherwise I lose it if I can only update the data using replace button
that is, I only need to do replace once, then it will be updates all the time
See if Update works like you want it to.
29218781b.xlsb
29218781b.xlsb
ASKER
i just hit Summary button at sheet1 get this :
ASKER
when hit by years button sheet1
ASKER
Have an Great Rest Time !
You lead the Way !
You lead the Way !
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
you did it as I need
it's a terrific great job
as always.....The Best !!
it's a terrific great job
as always.....The Best !!
Necesito una explicación más completa y / o la semana1 completada manualmente.