Multi Row Formula Expression Needed

bh1789

How would I use the multi row tool to find if the employee sid repeated on consecutive lines of data?  If empSID repeats on 2nd line that is the first repeat

Emp SID      Repeat

123456          no

123456          yes

123456          yes

123456          yes

456789          no

456789          yes

34589            no

Thank you

ed_hayter

This can be done by adding an extra clause to the multirow:

Now if either the row before or after has the same value then it is marked as repeat. Looking at each row at a time.

Updated workflow below

bh solution.yxmd