Comparing values until blank row

[ilovecoding]

Hello Geniuses,

I have a roles in a column wherein i have blanks after every 2 rows. All i'm checking is there has to be preparer and reviewer combination in each pair and NOT preparer-preparer or reviewer-reviewer combo. If so, all i need is 'good' to be populated in check column, here is the table

Role	Role check
(null)
Preparer	good
Reviewer	good
(null)
Preparer	good
Reviewer	good
(null)
Preparer	good
Reviewer	good

[gawa · Accepted solution]

hi @ilovecoding 

Multi Row formula can solve your case.

Though not mentioned in your post, I put "Not good" when condition is not met.

[ilovecoding]

Thank you very much

[ilovecoding]

Hey i applied the same logic to my another column where i m comparing sentences, basically a one liner. What i noticed is for majority of times it is giving me correct output as 'not good' for those where 2 lines are exactly identical, however for few it is giving me 'good' where both the lines are identical. Would you know why ?

see below, xxx is nothing but sensitive data.

Sanctioned xxx . Actual maturity date mm/year . xxx and xxx still reflect holdings.	Preparer	Good	good
Sanctioned xxx . Actual maturity date mm/year . xxx and xxx still reflect holdings.	Reviewer	Good	good

[gawa]

hi @ilovecoding *If possible, please mention like @XXXXX so I can receive notification, otherwise I would miss it

Can you change configuration of Multi Row Formula like this, and check the result again?

Values for Rows that don't Exist

0 or Empty => NULL

[ilovecoding]

@gawa - tried, didnt work :(

[gawa]

@ilovecoding Can you provide more sample data so that I can reproduce your issue at my end? 

[ilovecoding]

@gawa  Here is the table with the outcome i need in last 2  columns. For comments its working for majority but not for some. 

Comments	Role	Comment check	Role check
A for apple.	Preparer	Not good	Good
A for apple.	Reviewer	Not good	Good
B for ball.	Preparer	Good	Good
C for cat.	Reviewer	Good	Good

[ilovecoding]

If comments are same its 'not good'

[ilovecoding]

If comments are same it would be no good, also each such lines has one blank line on top. 

Comments	Role	Comment check	Role check
A for apple.	Preparer	Not good	Good
A for apple.	Reviewer	Not good	Good
B for ball.	Preparer	Good	Good
C for cat.	Reviewer	Good	Good
D for Dog.	Preparer	Good	Good
R for Rabit	Reviewer	Good	Good
J for Joker.	Preparer	Good	Good
M for Monkey	Reviewer	Good	Good
N for nose, Z for zebra	Preparer	Not good	Good
N for nose, Z for zebra	Reviewer	Not good	Good