If Statement needs to consider cell above value before processing outcome

[masond3]

Good Morning Excel Forum,

hope all is well.

I am hoping you can help me with a little scenario i am encountering.

I have two columns, Column A & Column B as represented below.

Column A Column B
12345 12345
12345 11111
12345 22222
12345 33333

In Column C i have a formula to say =A2=B2 which returns "True" or "False". which returns the following result set ;

Column A Column B Column C
12345 12345 TRUE
12345 11111 FALSE
12345 22222 FALSE
12345 33333 FALSE

Based on this i will then take the appropriate action based off column C and update Column B. However the problem i am encountering is that Column A can be associated to multiple codes in Column B. What i would like to say is, if A2 = B2, and A3 has the same value as A2, then C3 should = true.



Expected Out come

Column A Column B Column C
12345 12345 TRUE
12345 11111 TRUE
12345 22222 TRUE
12345 33333 TRUE

[Pete_UK]

Keep the formula in C2, but use this in C3:

=IF(C2,IF(A3=A2,TRUE,A3=B3),A3=B3)

Then copy down.

Hope this helps.

Pete