asked on 2N identify pairs button
2N identify pairs button and DD
as we did here but now for 2N :https://www.experts-exchange.com/questions/29229832/4n-identify-pairs-button.html
1-in columns X 1 in sheet1 button to
2- identify the consecutive pairs as it happens from ORD
(sheet DTON E3 to E12 have the table of consecutives)
3-Then Shown ALL the consecutive in Column X
4- In columns Z1 button to shown all the DD numbers like 88 or 44
in column Z
(sheet DTON G3 to G12 have the DD numbers)
Microsoft ExcelVBAMicrosoft Office
Last Comment
ADRIANA P
In the 4N version there are 6 kinds of consecutive pairs, but in 2N I assume there's only AB. Is that correct? If so you you want that column to be red or do you want it to be black?
ASKER
assume there's only AB. Is that correct?
yes!, Please !
Red, Please !
yes!, Please !
Red, Please !
In columns Z1 button to shown all the DD numbers like 88 or 44 in column ZDid we do that in 4N?
ASKER
Did we do that in 4N?
column GJ in 4N
column GJ in 4N
This does it a little differently than you requested; there's just one button.
29230152.xlsm
29230152.xlsm
ASKER
Best expert
can we see the DD and Consecutive At same time ??
can we see the DD and Consecutive At same time ??
Yes, just click the Consecutive Pairs button. Or do you always want to see all the DD values?
ASKER
Yes Please want to see consecutives and DD at same time!
rigth now when you click the button it shown the consecutives then later DD and is not rigth that way
the button name should be "conse"
rigth now when you click the button it shown the consecutives then later DD and is not rigth that way
the button name should be "conse"
Did you click the button twice? What o you mean by "then later DD and is not rigth that way"?
By the way, when you tell me that something is not done the right way you need to show me or tell me what the right way is, because if I knew what the right way was I would have done it that way. Otherwise I'm just guessing.
Por cierto, cuando me dices que algo no se hace de la manera correcta, debes mostrarme o decirme cuál es la manera correcta, porque si hubiera sabido cuál es la manera correcta, lo habría hecho de esa manera. De lo contrario, solo estoy adivinando.
Por cierto, cuando me dices que algo no se hace de la manera correcta, debes mostrarme o decirme cuál es la manera correcta, porque si hubiera sabido cuál es la manera correcta, lo habría hecho de esa manera. De lo contrario, solo estoy adivinando.
ASKER
Yes Please want to see consecutives and DD at same time! at same time in the windows no after
ASKER
i never say need an button to shown the consecutives and later the DD
i need see then at same time when i click the button
i need see then at same time when i click the button
i need see then at same time when i click the buttonIt does that now but perhaps not all the DDs.
When do you want to see the DDs?
Always?
After the you click the button that says "Consecutive Pairs"?
After the you click the button that says "All Pairs"?
ASKER
when i l click the button "Consecutive Pairs"
then i need see the consecutives and the DD
rigth now DD is shown with all pairs
Best Expert !! when i open the question I request an button apart for DD so i can have the option to shown DD as i need to shown
then i need see the consecutives and the DD
rigth now DD is shown with all pairs
Best Expert !! when i open the question I request an button apart for DD so i can have the option to shown DD as i need to shown
Why not show DD all the time?
ASKER
Why not show DD all the time?
when i click the Consecutives Pairs
it shown the consecutives but DD disappears
when i click the Consecutives Pairs
it shown the consecutives but DD disappears
I suggesting that DD should show all the time. OK?
ASKER
ok
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Great JOb !
The Best ! ! Expert !
The Best ! ! Expert !