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]

Replicated what you seem to be looking for

[bh1789]

I need a line-by-line for multiple instances of Emp SID ... is there a way to use more than 1 expression in multi-row formula?

[ed_hayter]

Not sure I understand. This current configuration goes line by line and checks the EMP SID with the one above. So even if the EMP SID appears 3 times in a row 2 and 3 will be recognized as repeats. The thing it does not currently cap

[bh1789]

You are right, but the first occurrence of the repeated EmpSID comes back as "no" and I need to include the first occurrence of the repeated EmpSid

Do you have an idea of how I could do that?

[ed_hayter · Accepted solution]

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