Calling Out Possible Duplicated Payments using Multi-Row Formula

[FUB_IA_SQL_GUY]

Problem:
I have a dataset of AP Payments I am trying to clean up in Alteryx. One of the requested items is to call out possible duplicated payments. There are no unique records recorded in our AP input software and the list comes out like the following:

Im wanting to use Alteryx to look for possible records based on the following Group By:

• Vendor/ID
• Payment Date
• Payment Type
• Check #
• Amount Due
• Net Amount

The hopeful outcome would look something similar to below:

I color coded the potential Duplicated records just to make it easier to see the results. Basically the logic would look for records with the same fields:

• Vendor/ID
• Payment Date
• Payment Type
• Check #
• Amount Due
• Net Amount

I have done something to this in SQL with LEAD and LAG and it looks like Multi-Row Formula Tool in Alteryx can accomplish this goal, I am just not sure how to set up the tool to get the desired results. I have created a sample YXMD workflow with the sample data above. 

Thank in advance for any input or help. 

[binuacs]

@FUB_IA_SQL_GUY One way of doing this

[FUB_IA_SQL_GUY]

@binuacs Ok I think I get the concept. Not sure how to setup the Summarize tool though. Your attachment just had my original flow without the additional steps added. Is this how I should set up my Summarize tool.

Thanks again for your help.

[binuacs]

@FUB_IA_SQL_GUY you need to take the count of Vendor ID, I will update the workflow but give a try from your side based on the screen shot 

[binuacs]

@FUB_IA_SQL_GUY Attaching the workflow