I think I would use the multi-row formula tool with multiple conditions? Thanks in advance

[bh1789]

[caltang]

Yes, you are on the right track.

[abacon · Accepted solution]

@bh1789  Throw this formula in a multi row tool after sorting on ID - 'IF ([Row-1:ID] = [ID] AND [Row-1:Date] != [Date] AND [Row-1:Type] = [Type]) OR [Row+1:ID] = [ID] AND [Row+1:Date] != [Date] AND [Row+1:Type] = [Type] then 'Match' else 'No Match' endif'. That should do it for you.

[binu_acs · Accepted solution]

@bh1789 

[bh1789]

Thank you for your assistance!  However, the 'Match' is only coming through on the first line, but not the second line.  Do you have suggestion as to how to fix that?  Thank you

[bh1789]

Thank you, your solution worked for me.