select data in 3n prs

as show
f1111.PNG
here the file
29089175_3nbase_select_repeat.xlsb
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

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

Martin LissOlder than dirtCommented:
Why are those cells different colors?
0
Martin LissOlder than dirtCommented:
Where do the numbers in columns DI:DK come from?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

Where do the numbers in columns DI:DK come from?

the source column is AY
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Martin LissOlder than dirtCommented:
I understand that, but why are some of them green and some of them violet?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

I understand that, but why are some of them green and some of them violet?

what need to achive here  is

as an DDBRO number is true

then

a1.PNG
0
Martin LissOlder than dirtCommented:
1) Why do you need the numbers in columns DI:DK?

2) If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
a111.PNG

1) Why do you need the numbers in columns DI:DK?

well as i try to explain  as better as i can
i show it this way

If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?


remember when an DDBRO appea  in the 13 row set  it make the point to establish the first week then the sencond week and 3 week
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
DDBRO is the base to follow
0
Martin LissOlder than dirtCommented:
If what you want to do is highlight the cells in the DDBRO and DBRO areas then you don't need columns DI to DK.

2) If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?
Please answer with either "4 to 6" or "2 to 4".

Si lo que quiere hacer es resaltar las celdas en las áreas DDBRO y DBRO, entonces no necesita las columnas DI a DK.

2) Si lo entiendo correctamente, la semana 1 muestra los resultados de las semanas 1 a 3. ¿Cuál es el próximo rango que se debe analizar? ¿Son las semanas 4 a 6 o son de 2 a 4?
Responda con ya sea "4 a 6" o "2 a 4"
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
2) If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?
Please answer with eather "4 to 6" or "2 to 4".


Martin i don't undestand this question


each DDBRO beging an new range of 3 weeks foward
0
Martin LissOlder than dirtCommented:
OK let me ask the question in a different way.

I assume that the cells in week 1 are highlighted based on the content of weeks 1 to 3. Are the cells in week 2 highlighted based on the content of weeks 2 to 4?

Supongo que las celdas de la semana 1 se resaltan en función del contenido de las semanas 1 a 3. ¿Se destacan las celdas de la semana 2 en función del contenido de las semanas 2 a 4?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1111111aaa.PNG
this the range of weeks for number 299
0
Martin LissOlder than dirtCommented:
That totally confuses me. I was looking for a simple "yes" or "no" answer,
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
That totally confuses me. I was looking for a simple "yes" or "no" answer,

patiente

the reason i dont answer is because i dont undertans the question

but each  DDBRO have his own weeks cycle

1111111aaa.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
 i have problems to explain this

remember each number that appear in DDBRO comes out because it have an repeat digit

in  the source column  AY
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1111111aaa.PNG
0
Martin LissOlder than dirtCommented:
I don't know how to be any clearer, but let's back up a bit.

Is the purpose of this question to highlight the cells in columns CX to DG? Please answer yes or no.

No sé cómo ser más claro, pero retrocedamos un poco.

¿El propósito de esta pregunta es resaltar las celdas de las columnas CX a DG? Por favor, responde sí o no.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Is the purpose of this question to highlight the cells in columns CX to DG? Please answer yes or no

Yes
0
Martin LissOlder than dirtCommented:
I can do that without putting anything in columns DI to DK. Is that OK?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Yes. That will be Great
0
Martin LissOlder than dirtCommented:
A while back you said "the source column is AY" and I agreed but the source is actually CG, correct?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
while back you said "the source column is AY" and I agreed but the source is actually CG, correct?

Yes ,
0
Martin LissOlder than dirtCommented:
OK., let me ask you these questions. Why is cell CX13 green? Is it because "24" appears in column CG for that week? If so why is DC13 pink since "79" is also in column CG for that week?

 I have some other things to do but I'll be back later.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
b111.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
OK., let me ask you these questions. Why is cell CX13 green? Is it because "24" appears in column CG for that week? If so why is DC13 pink since "79" is also in column CG for that week?

is not because that


let focus in column AY

when  number 299  ( im interest in numbers with repeat difgit like 99 in this number )

then i will have 3 weeks foward


then when number  669 hit  ( it have 66 repeat digit)

i will have 3 weeks foward   but  his 3 weeks dont have nothing  with the weeks for number 299


each repeat digit have his own week count  indpendet from each other

so 677 will have his own 3 weeks count and don't have nothing to be with  number 299 or 669
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1111ddddd.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1ggggg.PNG
0
Martin LissOlder than dirtCommented:
Are you saying that you believe that currently there is processing that spans 3 weeks?

¿Estás diciendo que crees que actualmente hay un procesamiento que se extiende por 3 semanas?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Are you saying that you believe that currently there is processing that spans 3 weeks?

for example lets take numbers 299

these are the pairs that comes from 299  = 24      27      29      47      49      79


then i need check  for 3 weeks (inside these 3 weeks)

if any combination appear

and  get marked  is in week 1  , week 2 or week3  after 299 hit
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Are you saying that you believe that currently there is processing that spans 3 weeks?

i can say an compare in an 3 weeks range for an number with 2 digit repeat
0
Martin LissOlder than dirtCommented:
Are you saying that you believe that currently there is processing that spans 3 weeks? Yes or no please.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
may  I ask what you mean with an processing??

because dont understand that
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i can say that in an 3 weeks outputs relatives will show
0
Martin LissOlder than dirtCommented:
I'm not asking about the future. Do you believe that in the workbook that you attached that the results in CX13 to DC13 come from more than one week?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Do you believe that in the workbook that you attached that the results in CX13 to DC13 come from more than one week?

no
0
Martin LissOlder than dirtCommented:
We're making progress now:)
I see that cell CX13 is 24 and it's green and that cell DC13 is 79 and it's pink is pink. Why is that since both are in CG13?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I see that cell CX13 is 24 and it's green and that cell DC13 is 79 and it's pink is pink. Why is that since both are in CG13?

No
0
Martin LissOlder than dirtCommented:
I see that cell CX13 is 24 and it's green and that cell DC13 is 79 and it's pink.  Both 24 and 79 are in CG13, so why is one green and one pink?

Veo que la celda CX13 es 24 y es verde y que la celda DC13 es 79 y es rosa. Tanto 24 como 79 están en CG13, entonces ¿por qué uno es verde y uno rosa?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

well i see you don't undertsand me

not either my pic
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i explain alredy where it comes from
0
Martin LissOlder than dirtCommented:
I'm talking about the workbook you posted.
 2018-03-16_12-53-56.png
i explain alredy where it comes from
If I understood your explanation I wouldn't be asking.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
can you  understand me with this

we are talking about one week for number 299

is ok ??

22aa.PNG
0
Martin LissOlder than dirtCommented:
can you  understand me with this
No, I can't because 79 is in the same week (in cell AY17) so why isn't cell DC13 green instead of pink?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
No, I can't because 79 is in the same week (in cell AY17) so why isn't cell DC13 green instead of pink?


22bb.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
when number 299 appeaR   it create his DDBRO and DBRO

then

 i need follow his 1 week  (green color)

then his 2 week ( pink color)

and  his 3 week ( blue color)

is any of the numbers that DDBRO associated to 299 appear in the  1week to 3week
0
Martin LissOlder than dirtCommented:
But you haven't answered my question. 79 is also in the first week so why isn't DC13 green? Without an explanation of that I can't do this for you.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
But you haven't answered my question. 79 is also in the first week so why isn't DC13 green? Without an explanation of that I can't do this for you.

ok i see my error you rigth

number 179 is with 79  shound be then green

my mistake because it appear in the   1 week range


x2222.PNG

sorry like i say in the begining i have problem to explain  this
because the weeks
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
in any case number 79 appear in week 1   but then in week 2

i don't know if an special color for the double hit could be used

to let me know is an double  hit in the 3 weeks follow
0
Martin LissOlder than dirtCommented:
OK, hopefully these will be the last questions. Please answer yes or no if you can.

Is a "week" Thursday to Wednesday?

Is CX13 which has a value of 24 green because there is a "24" in AY20 which is in the 7-day period from 1/5 to 1/11?

If so are you aware that the 24 in CX13 has nothing to do with the value in AY20?

You have talked about 3 weeks and so I assume that to color the cells in CX13 to DC13 that I should look in weeks 1/5 to 1/11, 1/12 to 1/18 and 1/19 to 1/25. Is that correct?

If it is correct, and I find a match only in 1/19 to 1/25, what color would the match in CX13:DC13 be?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Is a "week" is Thursday to Wednesday?

not.  

an week in this situation begings as an  DDBRO is create

the ddbro comes out of an number with repeat digit


299 is just the first

but  

669 follow

then
 677


then

999

and so on
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Is CX13 which has a value of 24 green because there is a "24" in AY20 which is in the 7-day period from 1/5 to 1/11?

yes ..

 number 299 create  the DDBRO and DBRO
 then  we need follow DDBRO and DBRO  in the 1 week then 2 week and  3 week  to see the numbers
that  show up from DDBRO and DBRO
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
If so are you aware that the 24 in CX13 has nothing to do with the value in AY20?


as they have one of the pair from DDBro and Dbro
that what i need
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
You have talked about 3 weeks and so I assume that to color the cells in CX13 to DC13 that I should look in weeks 1/5 to 1/11, 1/12 to 1/18 and 1/19 to 1/25. Is that correct?

I don't understand this question

but

number 299 create the ddbro and dbro

then in the first 7 days ( 1 week) any pair that appear in this range shoud be color in CX13 to DG 13

as green because is the first week

2 week  range pink
3 week  range  blue
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
If it is correct, and I find a match only in 1/19 to 1/25, what color would the match in CX13:DC13 be?

fro number 299 that will be the 3 week should be color ligth blue
like this

33333aaaaaa.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
DDBRO and DBRO are only created when an repeat digit number appear

then  

3 weeks for that DDBRO and DBRO is follow to see what numbers
have the pair that DDBRO have in

but the 3 weeks is for each DDBRO created
and each one is independet  of  each other
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
what i mean for any DDBRO and DBRO
created

we need follow it  by 3 weeks

to see what pair comes true
0
Martin LissOlder than dirtCommented:
Is a "week" is Thursday to Wednesday?

not.  
What???

What does this mean then? It seems to clearly show that a week is Thursday to Wednesday.
2018-03-16_14-57-58.png
I don't understand most of the rest that you just said but I'm going to make changes to the workbook and then you can tell me if it's correct or not.
0
Martin LissOlder than dirtCommented:
Question: I assume that week 1 for the data in CX13:DC13  is Thursday AM to Wednesday Pm, in other words rows 12 to 24. What is week 1 for the data in CX22:DC22?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
What does this mean then? It seems to clearly show that a week is Thursday to Wednesday.

yes

2345.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I assume that week 1 for the data in CX13:DC13  is Thursday AM to Wednesday Pm, in other words rows 12 to 24. What is week 1 for the data in CX22:DC22?

you rigth  each day have an am and pm  

in this case the numbers appear just in PM

but will be show with AM and PM foward


in the case of number in CX22:DC22

here the week


44444aaaaa.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
for the data in CX13:DC13

2345.PNG
0
Martin LissOlder than dirtCommented:
OK, so far this does only DDBRO. Please check the results carefully and if you see a problem with the colors, please report the problem like the following example. (I don't need pictures)
OK, hasta ahora esto solo hace DDBRO. Verifique los resultados cuidadosamente y si ve un problema con los colores, informe el problema como en el siguiente ejemplo. (No necesito fotos)

Cell DC13 should be blue because AY33 contains 79

We both know that DC13 should be green and the above is just an example.
Los dos sabemos que DC13 debe ser verde y lo anterior es solo un ejemplo.
29089548.xlsb
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

need an button to  apply  this the a new  data added
0
Martin LissOlder than dirtCommented:
When you click DDBRO it will happen automatically.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

looking great to me



CX147 :DB147

it show  0   5  

should be  00  05

when 0 leading
0
Martin LissOlder than dirtCommented:
Updated. Let me know if you see any of the little green triangles in the DDBRO columns.

If you say this workbook is OK I'll make the required changes to DBROW.
29089548a.xlsb
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

one more change will help  me

the color

Capv111.PNG
0
Martin LissOlder than dirtCommented:
Where does that color come from?
1
Martin LissOlder than dirtCommented:
Never mind I found it.
1
Martin LissOlder than dirtCommented:
Where does the pink color come from?
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
111111444444.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

when look for numbers like 577 in AY

you see all  are  green with  57 pair in DC but is not in 1 week range


adjusted are needed
0
Martin LissOlder than dirtCommented:
From everything you've said I assume that the rows under DDBRO that have data determine where week 1 starts. For example the first row with DDBRO data is 13 and so week 1 starts at row 13. So, since there is DDBRO data in row 126, week 1 for that data starts at row 126, and since 577 is in AY126 it is in week1.
0
KoenChange and Transition ManagerCommented:
what a struggle... Martin, I take my hat off for that much devotion.  :-)
0
Martin LissOlder than dirtCommented:
Thanks but am I correct when I said this?
From everything you've said I assume that the rows under DDBRO that have data determine where week 1 starts. For example the first row with DDBRO data is 13 and so week 1 starts at row 13. So, since there is DDBRO data in row 126, week 1 for that data starts at row 126, and since 577 is in AY126 it is in week1.
0
Martin LissOlder than dirtCommented:
While I'm waiting for your answer, try this.
29089548b.xlsb
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
From everything you've said I assume that the rows under DDBRO that have data determine where week 1 starts.

Yes !
 each DDBRO have his on 3 weeks


for example we begings  with

at CX13  which have 3 weeks to look for

but  

then

we have

CX26 which have his own 3 weeks

then


CX 24  which have his own 3 weeks to looks for

they are near each other but they are independent each one of the other
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Also each  DDBRO can not count itself

because we are looking for see the  repeat pairs that come from  the

DDBRO but not counting it self  (after it)
0
Martin LissOlder than dirtCommented:
Also each  DDBRO can not count itself

because we are looking for see the  repeat pairs that come from  the

DDBRO but not counting it self  (after it)
Are you telling me that there's a problem?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
for example

AY126     577   create  CX126     20      25      27      05      07      57

number 57  appear in 3 week   then shou be  blue ligth   but appaer green color

and do the same for all the 57 that appear for  577 when you look for
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Also the correct  12 count 12 rows after the DDBRO appear

so it make the fisrt week then 12 rows make the second week   then 12 rows make the third week  

each week is an 12 rows an set
0
Martin LissOlder than dirtCommented:
Again I can't tell if you are reporting a problem. For now please simply list the rows for the DDBROW in row 13. I assume they are

Week 1  12: to 24
Week 2  25: to 37
Week 3  38: to 50
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

trying to get the data for 577

i have problems
0
Martin LissOlder than dirtCommented:
Please just answer my question.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Week 1  12: to 24
Week 2  25: to 37
Week 3  38: to 50


this is ok
0
Martin LissOlder than dirtCommented:
But for week 1 you are telling me that row 13 shouldn't be included. Is that correct?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Is that correct?

yes you are correct
0
Martin LissOlder than dirtCommented:
If the DDBRO were in row 12 (Thursday AM) should I include values found in row 13 (Thursday PM)?
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
If the DDBRO were in row 12 (Thursday AM) should I include values found in row 13 (Thursday PM)?

yes !
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
after any question you have

can we see 577 in AY  i need show an problem i have
0
Martin LissOlder than dirtCommented:
Please tell me now.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
when i look for  numbers 577 in AY to find the DDBRO
i found 57 is all green mark

but for example  

in the first 577 search  it appear in row 126

but then 57 is not in the  1 week is in the 3 week
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then the second 577 appear in row 802

and 57 in his second week

but in this 2 examples 57 is marked green as it was in first week
0
Martin LissOlder than dirtCommented:
Try this.
29089548c.xlsb
1

Experts Exchange Solution brought to you by

Your issues matter to us.

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

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

working as needed

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

From novice to tech pro — start learning today.