match with table data 2N
1- In DTO columns AJ to AX is table 2DR
2- match column BF sheet1 with column AJ in DTON
3- then show in sheet1 column AJ to AX
as shown :
Martin Liss
I assume that we did this in the 3N workbook. What is the name of the button in that workbook?
ASKER
in 3N and 4N we have made TRIG button similar
but we have never done 2DR
Trig is similar and is the TRIG BS1 button
another similar is DTON button in ax1 similar
but we have never done 2DR
Trig is similar and is the TRIG BS1 button
another similar is DTON button in ax1 similar
ASKER
ok i see in 3n in DDX DTON button it is quite similar
In the sample workbook why are some cells like AL7 green?
ASKER
AL7 is green because it came out in BF after being predicted it was a hit
In your picture is the data and colors you show meant to be accurate and complete?
¿En su imagen, los datos y los colores que muestra están destinados a ser precisos y completos?
¿En su imagen, los datos y los colores que muestra están destinados a ser precisos y completos?
ASKER
More combinations will be studied to be added in the table 2DR in DTON columns AJ to AX
if the question is whether the table will increase or be adjusted, it is yes
the colors are as needed
hits are green in a week
if the question is whether the table will increase or be adjusted, it is yes
the colors are as needed
hits are green in a week
No that's not what I'm asking. I'm doing some testing now and my results do not match your picture. Is that picture accurate and complete given the current 2N DTON worksheet?
No, eso no es lo que estoy preguntando. Estoy haciendo algunas pruebas ahora y mis resultados no coinciden con su imagen. ¿Es esa imagen precisa y completa dada la hoja de trabajo actual de 2N DTON?
No, eso no es lo que estoy preguntando. Estoy haciendo algunas pruebas ahora y mis resultados no coinciden con su imagen. ¿Es esa imagen precisa y completa dada la hoja de trabajo actual de 2N DTON?
ASKER
Is that picture accurate and complete given the current 2N DTON worksheet?
yes !!
i did line by line
yes !!
i did line by line
Why doesn't row 5 show everything that's in DTON AJ35 to AX35?
ASKER
sorry my mistake i added in DTON after did the sheet1 but should be shown
I don't think that AK5 should be green because as I understand it the one-week period should be BF6 to BF20.
ASKER
is at same week Best Expert !!
you means 69 ?? AL7 ??
you means 69 ?? AL7 ??
Try this.
29232136.xlsm
29232136.xlsm
ASKER
Great Job !!
Best Expert
please can be adjust to let the column BF at originals color
need the color stay only in columns AJ to AX
Best Expert
please can be adjust to let the column BF at originals color
need the color stay only in columns AJ to AX
Corrected.
29232136a.xlsm
29232136a.xlsm
ASKER
Best Expert !! please ! verify it ...
I apologize because sometimes I have to write fast and I don't say the complete sentence or I think I haven't written it and when I check it is not written correctly
nothing happens after the click the DTON button
can be the button DTON call "2DigitReturn"
I apologize because sometimes I have to write fast and I don't say the complete sentence or I think I haven't written it and when I check it is not written correctly
nothing happens after the click the DTON button
can be the button DTON call "2DigitReturn"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Corrected of the correction. Working !!!
Great Job !! Best Expert !!
Great Job !! Best Expert !!