4n to create keys from TP vertically and HOR
4N wPT wTRITOP to add Keys HOR, VERT
29219695c.xlsb
1- need create in FKEYS sheet the keys HORI and VERTI
for RANGE , PAIRS TOP , TRI TOP with one button for eachone
as we did for WEEK TOP NUM
as we did here :https://www.experts-exchange.com/questions/29219434/4n-to-create-keys-from-TP-vertically.html
29219695c.xlsb
1- need create in FKEYS sheet the keys HORI and VERTI
for RANGE , PAIRS TOP , TRI TOP with one button for eachone
as we did for WEEK TOP NUM
as we did here :https://www.experts-exchange.com/questions/29219434/4n-to-create-keys-from-TP-vertically.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
one question
do you suggest going that way?
do you suggest going that way?
ASKER
i means it affect the performance
ASKER
Great Expert !
Best Job!!
Best Job!!
It won't affect performance, but as more worksheets are added the workbook will grow in size.
ASKER
ok
lets do PAIR TOP and TRI TOP then
lets do PAIR TOP and TRI TOP then
ASKER
holdon the keys in the RANGE VERTICAL are not working
ASKER
Please Verify it
Is the vertical column in the FKEYS_TopNum worksheet correct?
ASKER
Is the vertical column in the FKEYS_TopNum worksheet correct?
yes !!
Well the vertical column in the FKEYS_Range worksheet does the same thing as FKEYS_TopNum. It takes the first digit of each of 10 horizontal cels in a week and puts them in the first cell in the vertical column. It then takes the second digit of each of 10 horizontal cels in a week l and puts them in the second cell in the vertical column, etc.
Bueno, la columna vertical en la hoja de trabajo FKEYS_Range hace lo mismo que FKEYS_TopNum. Toma el primer dígito de cada una de las 10 celdas horizontales en una semana y las coloca en la primera celda de la columna vertical. Luego toma el segundo dígito de cada una de las 10 celdas horizontales en una semana l y las coloca en la segunda celda de la columna vertical, etc.
Bueno, la columna vertical en la hoja de trabajo FKEYS_Range hace lo mismo que FKEYS_TopNum. Toma el primer dígito de cada una de las 10 celdas horizontales en una semana y las coloca en la primera celda de la columna vertical. Luego toma el segundo dígito de cada una de las 10 celdas horizontales en una semana l y las coloca en la segunda celda de la columna vertical, etc.
ASKER
I agree so it should be
That is supposed to be what is happening but it is not like that, something is out of phase
just look because all those zeros that are not the week
take a good look at column K vs ORD make no sense
That is supposed to be what is happening but it is not like that, something is out of phase
just look because all those zeros that are not the week
take a good look at column K vs ORD make no sense
ASKER
a lot of ceros where they come from ??
See if this makes any difference.
29220089a.xlsb
29220089a.xlsb
ASKER
please can you look the numbers in column K in Range Keys
look and compare
why you have a lot of ceros
can't be
look and compare
why you have a lot of ceros
can't be
ASKER
range is out of phase is not like TOP NUM keys column K
ASKER
you have to see the coulmn and count
ASKER
Because they are ranges and all ranges like 10, 20, 30, etc all end in zero.
ASKER
we only use the right sideHow could I possibly know that?
the number are inverseThat's not how it is done in FKEYS_TopNum.
ASKER
we use the left side only in range each column
ASKER
this is the right way to be
ASKER
in verti we take each column from range then make it horintally as shows
you did right the HOR
than now take the coulmns each one by one then make verti
you did right the HOR
than now take the coulmns each one by one then make verti
I understand.
ASKER
i see hor is too long have to be verify sholud be 12 horizontally
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes is better !!
need do Pairs Top and Tri Top
need do Pairs Top and Tri Top
Are they done the same way as Week Top Num?
ASKER
yes !!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
lets do TRi please !
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh my GOD !!! wao !!
you !! faster than
Intel Core i9-9980XE Extreme Edition Processor. w 4.40 GHZ Max Turbo Frequency
you !! faster than
Intel Core i9-9980XE Extreme Edition Processor. w 4.40 GHZ Max Turbo Frequency
ASKER
Great JoB !!
Best Expert !
Best Expert !
Eso no es un problema para mí, pero para que lo sepas, eso agregará 9 hojas de trabajo nuevas al libro de trabajo.