ADRIANA P

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

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

I don't understand the requirements.

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

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...?

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

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

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?

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

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)

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?

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?

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

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?

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 )

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?

ASKER

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

No

No

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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

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