4N add count 3N

have this 4N file

then  want  add this

a1.PNG
to the  FAM TRI  AND FAM DD

a22.PNG4N_doubles_samples.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:
What part of the 'Counts 2n' sheet do you want to add? Where should it go?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
Martin LissOlder than dirtCommented:
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?
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.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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   ??
Martin LissOlder than dirtCommented:
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.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
"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 ??
Martin LissOlder than dirtCommented:
I have no way of answering that so you need to decide.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
add  FAM TRI  and TRI DDD  to  'DTA 2n' or DTA 3n'

then Please!
Martin LissOlder than dirtCommented:
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"?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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 ??
Martin LissOlder than dirtCommented:
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'"?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
Martin LissOlder than dirtCommented:
otherwise we can create an sheet just only for  FAM TRI  and TRI DDD   in the 4n file

OK, I'll do that.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great ! ;)
Martin LissOlder than dirtCommented:
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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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:

a1.PNG
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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
sheet:   Fam Tri & Fam DD  should be like this
a2.PNG
Martin LissOlder than dirtCommented:
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'?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
hat order should they be in?

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

yes!

will need an blank column between them
Martin LissOlder than dirtCommented:
There are no hyperlinks yet but please verify that these values are correct so far.2018-10-28_09-46-51.png
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
should be like this

a3.PNG
Martin LissOlder than dirtCommented:
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?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok i see

why not

create the ORD FAM  in the new sheet so you just copy it
Martin LissOlder than dirtCommented:
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?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok  

but will need the count 2n   and count 3n too
Martin LissOlder than dirtCommented:
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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
No
 this the COUNT 2n  sheet needed

a444.PNG
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
because is alreday in this file i think was moew easy  create the FAM TRI and FAM DDD here
Martin LissOlder than dirtCommented:
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).
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok but  need it for repeat Digit

example    6885
Martin LissOlder than dirtCommented:
It currently asks you for the number. Is that still okay?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
Martin LissOlder than dirtCommented:
Are you talking about something like what happens when the 'Convert 0 Number 2n' button is clicked?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
well

 i see what you means now

yes but for repeat digit
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
Martin LissOlder than dirtCommented:
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'?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
YES it will
Martin LissOlder than dirtCommented:
Status report: I've been busy but I'm still working on it.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
;)
Martin LissOlder than dirtCommented:
This is not done. So far it only does the pairs. There's no need to click the 'Convert Duplicates' button because in this workbook I've already done that, but if you do it will take a couple of minutes to run. I didn't realize how much code was involved but there's a lot and I may have made some mistakes so please examine the results carefully and let me know what errors you find.
29123792.xlsb

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:
looking good to me by now
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Tremendous!
Martin LissOlder than dirtCommented:
Why did you say that that's the answer? It's not done yet.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok
Martin LissOlder than dirtCommented:
This version has both Pairs and Triples processing. While the Pairs process takes about 15 seconds to run, the Triples process takes about 2 minutes. I don't know why it takes that long and I'll try to improve it.
29123792a.xlsb
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
some tri are missin
Martin LissOlder than dirtCommented:
some tri are missin
Please don't make me guess which ones.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
original  row 8  taking this as sample

a1.PNG
this the white are missin
in  the first row  
a2.PNG
the second is the last you did
Martin LissOlder than dirtCommented:
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.
Martin LissOlder than dirtCommented:
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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

881      883     833  133 should be present too in when "CONVERT DUPLICATES TRIPLES"  is press  in that new section you create
Martin LissOlder than dirtCommented:
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?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok  i see

theses  VALUES 881      883     833  133

comes aout from FAM TRI Section

can you see the logic of   FAM TRI  ??
Martin LissOlder than dirtCommented:
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.
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
VBA

From novice to tech pro — start learning today.