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

match ord with dton 4n

4n to add 4n consecutive and 3n consecutive

29224717a.xlsb

1- create an button in  BA1   BB1  call it CONSE


2- in sheeet DTON Column Z are the 4 consecutives match  then showsup in sheet1 Column BA for ORD  column BF


3- in sheet DTON column AD are the 3n consecutives then showsup in sheet1 column BB for ORD column BF


as shown:


Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
ADRIANA P

I agree with your observation
Thanks for the correction, it's true

but when I press the CONSE button it shows me the consecutive tri in the columns BB


but it doesn't show me the consecutive 4n's in BA

Martin Liss

I forgot to add the code to the button.
29224767a.xlsb
ASKER
ADRIANA P

Great Job !!
 Best Expert !
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
Martin Liss

Adriana, please un-select my last comment as an answer; I should not be rewarded for a mistake.

Adriana, anula la selección de mi último comentario como respuesta; No debería ser recompensado por un error.
ASKER
ADRIANA P

still not shown 
Martin Liss

2021-09-21_10-53-30.png
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ADRIANA P

Best expert in the file you upload is not showing in column BA


29224767a.xlsb 
please ve rify  
ASKER
ADRIANA P

Martin Liss

In the workbook you attached I see 2413 in cells, BA2068, BA4213 and BA6358.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
ADRIANA P

the last file you upload is 29224767a.xlsb 

it makes the 3N but did not appear the 4n as your pic

make some mistake please verify this file 29224767a.xlsb 

i don;t have any other with this solution
Martin Liss

I deleted that file from my Downloads folder and uploaded the one you attached at the end of the "make some mistake..." line and I see this
Most recent image
If you are still not seeing the results then completely exit Excel and reboot.
Martin Liss

Okay I now know that 2413 is shown but other values are not, I was able to find the problem. I will correct it in your "match color 4n dton" question.

Bien, ahora sé que se muestra 2413 pero no otros valores, pude encontrar el problema. Lo corregiré en su pregunta "match color 4n dton".
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ADRIANA P

:)