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

Adjust in the same column same digit by time

4N to adjust  

29227581c.xlsb


1- situations  in 3 column of AM  and PM   here 2 samples but have more situations


2-this PM sample


3- this AM



Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Please take a look at this question I asked a few days ago. You said you agreed. This is a similar situation and I believe AD3951 should be blank because the 3 in N3951 is not near the 1 in N3945.

Eche un vistazo a esta pregunta que hice hace unos días. Dijiste que estabas de acuerdo. Esta es una situación similar y creo que AD3951 debería estar en blanco porque el 3 en N3951 no está cerca del 1 en N3945.
ADRIANA P

ASKER
speaking of 1 2 3 we have:

1

1

2

3


is related to 2


the rule says

1-equals
2- one up
3- one down


in this situation the 2 and 3 yes

11 repeat but 1 2 if they are on the rule

the result should be

1 1 2 3
Martin Liss

Then why did you say you agreed before? I based my solution on the fact that you agreed.
Entonces, ¿por qué dijiste que estabas de acuerdo antes? Basé mi solución en el hecho de que estabas de acuerdo.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ADRIANA P

ASKER
If my assumptions are correct then the 123 you show in AB1011 is NOT correct because the 3 in cell T1011 is NOT near the 1 in T1007 and so I believe that the AB1011 should be blank. Do you agree? 

when we talk about 1 and 3   they are not way to put together

but if 1  then 2  then 3 are in  chain they have to be shown


corrected



ADRIANA P

ASKER
Good! I could have been confused
but identify was wrong
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 !
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.