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

Microsoft ExcelVBAMicrosoft Office

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

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

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

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

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.

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?

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?

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

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?

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 )

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

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

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

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

No

No

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

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