# 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

Martin Liss

I don't understand the requirements.

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

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?

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?

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

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.