Find Duplicate records with multiple conditions

Question

Hi,

Can you some one please help me with find duplicate records with multiple conditions. if any of the > 2 records match with any condition it should be identify as duplicate. Attached excel file with example's condition.

Duplicate contions.xlsx

saveeshkumar · Answer

Hi @Lalaiah,

Please check and confirm.

Thanks.

Duplicate.yxmd

ArtApa · Answer

Hi @Lalaiah - Not the most elegant workflow, but hope it meets your requirements:

Name Duplicate Type
All unique Null
All duplicates 1
Supplier Number 2
Invoice Date 3
Invoice Number 4
Invoice Amount 5

DuplicatesAA.yxmd

Lalaiah · Answer

Hi Saveesh,

Thanks for your quick response and workflow.

In this case, duplicates are capturing only if they are above and below 1 row, but they must be searched as a whole. There may be multiple duplicate lines, so they should be sorted one by one.