4N add count 3N

What part of the 'Counts 2n' sheet do you want to add? Where should it go?

all the count 2  is neeeded   in an new sheett

 
Also  create the FAM TRI  and TRI DDD in the 4N  last file you did could be so the count 2 is already there

Are you saying that the 4N workbook should have FAM TRI  and TRI DDD added to the 'DTA 2n' and DTA 3n' sheets, and that the workbook that you uploaded should have a new sheet added which looks like the 'Weeks Selected 2n' sheet?

1- need count 2n for  FAM TRI  and TRI DDD

you recommend  make it in this file 4N_doubles_samples.xlsb    or keep it in  29123776.xlsm and add the FAM TRI  and TRI DDD   ??

1- need count 2n for  FAM TRI  and TRI DDD

You didn't say if it should be added to the 'DTA 2n' or DTA 3n' sheet or both.

you recommend  make it in this file 4N_doubles_samples.xlsb    or keep it in  29123776.xlsm and add the FAM TRI  and TRI DDD   ??

I don't understand.

"1- need count 2n for  FAM TRI  and TRI DDD
You didn't say if it should be added to the 'DTA 2n' or DTA 3n' sheet or both."

do you think add  FAM TRI  and TRI DDD  to  'DTA 2n' or DTA 3n'  will be better ??

I have no way of answering that so you need to decide.

add  FAM TRI  and TRI DDD  to  'DTA 2n' or DTA 3n'

then Please!

OK, put what about "you recommend  make it in this file 4N_doubles_samples.xlsb    or keep it in  29123776.xlsm and add the FAM TRI  and TRI DDD" which I didn't understand"?

here the  4N
29123776--1-_4N_to_ADD_fam_TRI_FAM_.xlsm

OK, put what about "you recommend  make it in this file 4N_doubles_samples.xlsb    or keep it in  29123776.xlsm and add the FAM TRI  and TRI DDD" which I didn't understand"?

i mean the same as we talk already

do you think add  FAM TRI  and TRI DDD  to  'DTA 2n' or DTA 3n'  will be better ??

Sorry but I'm still uncertain what you want to do. When you say "add  FAM TRI  and TRI DDD  to  'DTA 2n' or DTA 3n'" to you mean "add  FAM TRI  and TRI DDD  to  'DTA 2n' and DTA 3n'"?

need work with  FAM TRI  and TRI DDD
in

DTA 2n  otherwise we can create an sheet just only for  FAM TRI  and TRI DDD   in the 4n file

otherwise we can create an sheet just only for  FAM TRI  and TRI DDD   in the 4n file

OK, I'll do that.

Great ! ;)

Please take a look at this. It's not done and the only reason I'm posting it is so we can talk about a problem.. When you click the 'Family Tri' button on the new sheet, columns 'AO:AM' are copied to the sheet and Family Tri processing is done on the data in column 'C' (formerly 'AM').  The problem is that the family tri processing in the workbook that you attached is done against data that's always 6 digits long and that's not the case with the data in column 'C'. For example 'C81' is 240000133333999. What should the family tri result for that number be?

Por favor, mira esto. No está listo y la única razón por la que lo publico es para poder hablar de un problema. Cuando hace clic en el botón 'Family Tri' en la nueva hoja, las columnas 'AO: AM' se copian en la hoja y en Family Tri el procesamiento se realiza en los datos de la columna 'C' (anteriormente 'AM'). El problema es que el procesamiento triple de la familia en el libro que adjuntó se realiza contra datos que siempre tienen 6 dígitos y no es el caso de los datos en la columna 'C'. Por ejemplo, 'C81' es 240000133333999. ¿Cuál debería ser el resultado de la familia tri para ese número?
29123792.xlsm

MARTIN

you bring to me a new idea  

BUT FAM TRI  AND FAM DDD

can't  not be like that

the source is column A the ones with  repeat digit


example:


sheet:   Fam Tri & Fam DD  should be like this

in 4n  the source will be column
i mean column A and column B and column AM (date) are needed

here an file
4N_doubles_samples.xlsb

sheet:   Fam Tri & Fam DD  should be like this

Okay, when I copy columns 'A', 'B' and 'AM' from the DTA 2n sheet to the new sheet, what order should they be in? 'AM', 'B', 'A'?

hat order should they be in?

 'AM', 'B', 'A'?

yes!

will need an blank column between them

There are no hyperlinks yet but please verify that these values are correct so far.

should be like this

It can't be, at least not without a lot more work. The FAM TRI output in the workbook you attached is based in the ORD FAM data which is 6 digits. It is my understanding that you want to do something similar, but based directly on the ORD value which is a 4-digit number. Is that correct?

No puede ser, al menos no sin mucho más trabajo. La salida de FAM TRI en el libro que adjuntó se basa en los datos de ORD FAM que tienen 6 dígitos. Tengo entendido que desea hacer algo similar, pero basado directamente en el valor ORD que es un número de 4 dígitos. ¿Es eso correcto?

ok i see

why not

create the ORD FAM  in the new sheet so you just copy it

why not create the ORD FAM  in the new sheet so you just copy it

That's the "lot more work" I mentioned and it's too much to do for just one question.

But before we go any further let me ask you this. Would an acceptable solution be to just add 'Weeks Selected 2n' and/or 'Weeks Selected 3n' data to the 4N_doubles_samples.xlsb workbook?

ok  

but will need the count 2n   and count 3n too

When you say that you need Counts 2n and Counts 3n, I think what you are really saying is that you want a 'Count Hits' button for 2n and 3n. If so then I suggest that I do that first, but remember, 'Count Hits' counts the hits for one ORD at a time, and the ORD does not have to contain a duplicate. I can do that first if you want me to.

Cuando dices que necesitas Counts 2n y Counts 3n, creo que lo que realmente estás diciendo es que quieres un botón 'Count Hits' para 2n y 3n. Si es así, sugiero que lo haga primero, pero recuerde que 'Count Hits' cuenta los aciertos para una ORD a la vez, y la ORD no tiene que contener un duplicado. haga

No
 this the COUNT 2n  sheet needed

because is alreday in this file i think was moew easy  create the FAM TRI and FAM DDD here

No
 this the COUNT 2n  sheet needed

Just to make sure you understand - that's the result of choosing one ORD value (6880 in the picture).

ok but  need it for repeat Digit

example    6885

It currently asks you for the number. Is that still okay?

the way is rigth now  COUNT 2N is for 0 base  


what i need is put the same but for an repeat digit

the FAM TRI and FAM DDD are repeat digit

Are you talking about something like what happens when the 'Convert 0 Number 2n' button is clicked?

well

 i see what you means now

yes but for repeat digit

the same but  now not for 0  but for repeat digit

the repeat digit can have 0

but is not only for 0 like it is now

As a solution to this question would it be okay if it was just a new 'Convert Duplicates' button on Sheet1 to the right of column 'MT'?

YES it will

Status report: I've been busy but I'm still working on it.

;)

looking good to me by now

Tremendous!

Why did you say that that's the answer? It's not done yet.

ok

some tri are missin

some tri are missin

Please don't make me guess which ones.

original  row 8  taking this as sample


this the white are missin
in  the first row  

the second is the last you did

Let's talk about row 8.

Are you saying that there are tri values missing? If so please give me an example of one that is missing.

Are you saying that there are tri hyperlinks missing? If so please give me an example of one cell in that row (between columns 'NS' and 'OO') that should have a hyperlink, and the cell address in column 'BF' that it should link to.

I compared a few of the values and the hyperlinks in this workbook against the ones in the 4N workbook and they look the same. Keep in mind that the data in the 4M workbook starts in row 5 and in this workbook it starts row 6 when I say that...

The tri results in 20 of the 4N match the results in row 21 of this workbook
The tri results in 28 of the 4N match the results in row 29 of this workbook
The tri results in 44 of the 4N match the results in row 45 of this workbook

Martin

881      883     833  133 should be present too in when "CONVERT DUPLICATES TRIPLES"  is press  in that new section you create

If you are talking about row 8, the value in 'BF' is 6683 and there are only 3, 3-digit permutations of  6683 and they are 683, 663 and 668. We then do several things:
We add 5 to the 1st digit which results in 681, 613 and 813
We add 5 to the second digit which results in 681, 613 and 633
We add 5 to the 3rd digit which results in 663, 668 and 688
We add 5 to all three digits which results in 113, 811 and 813
We show each digit of the 'BF' value 3 times which results in 666, 666, 888 and 333
Finally we add five to each of the digits in those numbers which results in 111, 111, 333 and 888.

What if anything am I doing wrong?

ok  i see

theses  VALUES 881      883     833  133

comes aout from FAM TRI Section

can you see the logic of   FAM TRI  ??

I don't know why you are talking about Family tri since we agreed that "As a solution to this question [it would] be okay if it was just a new 'Convert Duplicates' button on Sheet1 to the right of column 'MT' and I've dine that. If you have a new question then please ask a new question.