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]

@ilovecoding 

I modified the logic applied in Multi Row formula as attached. In previous WF, I used IsNull() function but your real data might have "Empty string" or "White space" instead of null. So first I trim unnecessary space by Muti Field Formula, then use Multi Row Formula with IsEmpty() function instead of IsNull().

Can you check the revised WF works well or not. I hope this does not go worse...😅