Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

2N identify pairs button

2N  identify  pairs button and DD

29230038 (1).xlsm

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

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

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?
ADRIANA P

ASKER
assume there's only AB. Is that correct?
yes!, Please !

Red, Please !
Martin Liss

In columns  Z1 button to  shown all the DD numbers like 88  or 44 in column Z
Did we do that in 4N?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
Did we do that in 4N?

column GJ in  4N
Martin Liss

This does it a little differently than you requested; there's just one button.
29230152.xlsm
ADRIANA P

ASKER
Best expert

can we see the DD and Consecutive  At same time ??
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

Yes, just click the Consecutive Pairs button. Or do you always want to see all the DD values?
ADRIANA P

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"
Martin Liss

Did you click the button twice? What o you mean by "then later DD and is not rigth that way"?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Martin Liss

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.
ADRIANA P

ASKER
Yes Please want to see consecutives and DD at same time! at same time in the windows   no after 
ADRIANA P

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 
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

i need see then at same time when i click the button
It 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"?
ADRIANA P

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

 


Martin Liss

Why not show DD all the time?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ADRIANA P

ASKER
Why not show DD all the time?

when i click the Consecutives Pairs
it shown the consecutives but DD disappears
Martin Liss

I suggesting that DD should show all the time. OK?
ADRIANA P

ASKER
ok
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Martin Liss

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Great JOb !

The Best ! ! Expert !