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

in the same column same digit

4n to add  the same or 1up or 1 down  to  of column L to column T

29227325.xlsb


1- in column L  (only)  identify the same number follow or the 1up or  1down 


2- then shown in column T 


3- Button  in Colmun T call it  1D 

or any recommendation




Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

I don't understand the requirements.
ADRIANA P

ASKER
1- this will be for column L only

2- identify digits:

1-that are the same
2- or have one up
3-  or have one down


have to be in sequence

i means can not be out of sequence





Martin Liss

Please explain 78 and 787 using the specific numbers and specific cell values. For example cell T28 is 78 because...?
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
in each week in the column Lwe see same numbers


by week set











ADRIANA P

ASKER
Please explain 78 and 787 using the specific numbers and specific cell values. For example cell T28 is 78 because...? 


ok we see  7 the next is 8  is an follow
so we identify it

then shown in column T after  the pair


I am interested in 3 situations regarding a digit in column L
1- let it be the same 77
2- that one above that number 87 78
3- or let it be one less than that number 67 76

ADRIANA P

ASKER
another way of looking at it is we look at the couples

but they are the couples from top to bottom in the week in the same column


if there is a number q is the same or is one above or one below

then we are interested and select it in column T
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

I'm still stumped. What are the 7 and 8 in cells L53 and L55 matching?

Todavía estoy perplejo. ¿Qué coinciden el 7 y el 8 en las celdas L53 y L55?
ADRIANA P

ASKER
it is not difficult at all !!

in every week
specifically in column L (IN THIS CASE)

let's look at the numbers per week
when a number has

1- a repetition
or
2- it has a number that is above
or
3- a number q is down in the same columns L
that interests us and we call it the columns T


In this case, what do 7 and 8 coincide in cells L53 and L55?
talking about this situation

7 appears
8 follows therefore it is 78 applies the rule of one above

because we look at the number this way

6
7
8

How in this case 8 follows 7 and is one above 7 we would be interested in showing it in column T


We already know that the rule is 3 parts and it says

1- they are repeated the same = 77 (not this case)
2- has one above = 78 (if this is the case)
3- It has one down 67 (not this case)
Martin Liss

I think maybe that I understand now but I just noticed a problem. Near column Q there is a button called 4NPAIR. Where should that button be and what is it supposed to do?

Creo que tal vez lo entiendo ahora, pero acabo de notar un problema. Cerca de la columna Q hay un botón llamado 4NPAIR. ¿Dónde debería estar ese botón y qué se supone que debe hacer?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ADRIANA P

ASKER
Where should that button be and what is it supposed to do?

4N PAIRS
 
creates the sheet 4NPAIRS what it does is that it takes an ORD number

and turns it into pairs

it also converts them to TRI in the TRI_4n sheet
Martin Liss

Is the button in the correct column?
ADRIANA P

ASKER
it was put in Q2   but when   i unhide  the columns in that area
it  maybe it move  

but can be move to B2 at beginning  or any recommendation

i see an button  too in  U6   (may be is the same )

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Getting back to this question... What should 3W2012 look like?
ADRIANA P

ASKER

Martin Liss

Do you need the words "EVEN IS TRUE" IN ROW 3 column U?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ADRIANA P

ASKER
Do you need the words "EVEN IS TRUE" IN ROW 3 column U?


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

ASKER
Great Job ! Best Expert !!

I have to do some tests on the 4N pairs button
but right now I won't be able to

I will look for the question we asked and I will verify if it is working according to the answer you gave me