# select data in 3n prs

as show

here the file
29089175_3nbase_select_repeat.xlsb
###### Who is Participating?

Older than dirtCommented:
Try this.
29089548c.xlsb
1

Older than dirtCommented:
Why are those cells different colors?
0

Older than dirtCommented:
Where do the numbers in columns DI:DK come from?
0

ACCOUNTING ASSISTANTAuthor Commented:
MArtin

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

the source column is AY
0

Older than dirtCommented:
I understand that, but why are some of them green and some of them violet?
0

ACCOUNTING 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

0

Older 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

ACCOUNTING ASSISTANTAuthor Commented:

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

ACCOUNTING ASSISTANTAuthor Commented:
DDBRO is the base to follow
0

Older 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?

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

ACCOUNTING 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?

Martin i don't undestand this question

each DDBRO beging an new range of 3 weeks foward
0

Older 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

ACCOUNTING ASSISTANTAuthor Commented:

this the range of weeks for number 299
0

Older than dirtCommented:
That totally confuses me. I was looking for a simple "yes" or "no" answer,
0

ACCOUNTING 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

0

ACCOUNTING 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

ACCOUNTING ASSISTANTAuthor Commented:
0

Older 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

ACCOUNTING 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

Older than dirtCommented:
I can do that without putting anything in columns DI to DK. Is that OK?
0

ACCOUNTING ASSISTANTAuthor Commented:
Martin

Yes. That will be Great
0

Older than dirtCommented:
A while back you said "the source column is AY" and I agreed but the source is actually CG, correct?
0

ACCOUNTING ASSISTANTAuthor Commented:
Martin
while back you said "the source column is AY" and I agreed but the source is actually CG, correct?

Yes ,
0

Older 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

ACCOUNTING ASSISTANTAuthor Commented:
0

ACCOUNTING 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

ACCOUNTING ASSISTANTAuthor Commented:
0

ACCOUNTING ASSISTANTAuthor Commented:
0

Older 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

ACCOUNTING 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

ACCOUNTING 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

Older than dirtCommented:
Are you saying that you believe that currently there is processing that spans 3 weeks? Yes or no please.
0

ACCOUNTING ASSISTANTAuthor Commented:
may  I ask what you mean with an processing??

because dont understand that
0

ACCOUNTING ASSISTANTAuthor Commented:
i can say that in an 3 weeks outputs relatives will show
0

Older 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

ACCOUNTING 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

Older 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

ACCOUNTING 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

Older 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

ACCOUNTING ASSISTANTAuthor Commented:
Martin

well i see you don't undertsand me

not either my pic
0

ACCOUNTING ASSISTANTAuthor Commented:
i explain alredy where it comes from
0

Older than dirtCommented:
I'm talking about the workbook you posted.

i explain alredy where it comes from
0

ACCOUNTING ASSISTANTAuthor Commented:
Martin
can you  understand me with this

we are talking about one week for number 299

is ok ??

0

Older 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

ACCOUNTING 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?

0

ACCOUNTING 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

Older 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

ACCOUNTING 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

sorry like i say in the begining i have problem to explain  this
because the weeks
0

ACCOUNTING 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

Older 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

ACCOUNTING 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

ACCOUNTING 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

ACCOUNTING 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

ACCOUNTING 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

ACCOUNTING 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

0

ACCOUNTING 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

ACCOUNTING 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

Older 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.

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

Older 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

ACCOUNTING ASSISTANTAuthor Commented:
What does this mean then? It seems to clearly show that a week is Thursday to Wednesday.

yes

0

ACCOUNTING 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

0

ACCOUNTING ASSISTANTAuthor Commented:
for the data in CX13:DC13

0

Older 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

ACCOUNTING ASSISTANTAuthor Commented:
Martin

need an button to  apply  this the a new  data added
0

Older than dirtCommented:
When you click DDBRO it will happen automatically.
0

ACCOUNTING ASSISTANTAuthor Commented:
Martin

looking great to me

CX147 :DB147

it show  0   5

should be  00  05

0

Older 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

ACCOUNTING ASSISTANTAuthor Commented:
Martin

one more change will help  me

the color

0

Older than dirtCommented:
Where does that color come from?
1

Older than dirtCommented:
Never mind I found it.
1

Older than dirtCommented:
Where does the pink color come from?
1

ACCOUNTING ASSISTANTAuthor Commented:
0

ACCOUNTING 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

0

Older 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

Change and Transition ManagerCommented:
what a struggle... Martin, I take my hat off for that much devotion.  :-)
0

Older 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

Older than dirtCommented:
29089548b.xlsb
0

ACCOUNTING 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

ACCOUNTING 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

Older 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

ACCOUNTING 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

ACCOUNTING 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

Older 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

ACCOUNTING ASSISTANTAuthor Commented:
Martin

trying to get the data for 577

i have problems
0

Older than dirtCommented:
0

ACCOUNTING ASSISTANTAuthor Commented:
Martin

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

this is ok
0

Older than dirtCommented:
But for week 1 you are telling me that row 13 shouldn't be included. Is that correct?
0

ACCOUNTING ASSISTANTAuthor Commented:
Is that correct?

yes you are correct
0

Older than dirtCommented:
If the DDBRO were in row 12 (Thursday AM) should I include values found in row 13 (Thursday PM)?
1

ACCOUNTING ASSISTANTAuthor Commented:
If the DDBRO were in row 12 (Thursday AM) should I include values found in row 13 (Thursday PM)?

yes !
0

ACCOUNTING ASSISTANTAuthor Commented:
after any question you have

can we see 577 in AY  i need show an problem i have
0

Older than dirtCommented:
1

ACCOUNTING 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

ACCOUNTING 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

ACCOUNTING ASSISTANTAuthor Commented:
Great JOB !!

working as needed

Very best expet!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.