Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag 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


User generated image



Avatar of Martin Liss
Martin Liss
Flag of United States of America image

I don't understand the requirements.
Avatar of 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





Please explain 78 and 787 using the specific numbers and specific cell values. For example cell T28 is 78 because...?
in each week in the column Lwe see same numbers


by week set

User generated image









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

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
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?
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)
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?
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
Is the button in the correct column?
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 )

Getting back to this question... What should 3W2012 look like?
User generated image
Do you need the words "EVEN IS TRUE" IN ROW 3 column U?
Do you need the words "EVEN IS TRUE" IN ROW 3 column U?


No
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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