Moving the Unmatched row into another sheet in Excel

Hi Everyone,

can someone please help me to to achieve the following condition.

Need only two records (rows) of the same TXN NUMBER. If there is a third row with same TXN NUMBER need to check the “CREDIT AMOUNT” Column AND “DEBIT AMOUNT” Column Value must be same. If not matched that row needs to be moved to another sheet.

Attached Excel: Test.xlsx (9.2 KB)

Much appreciated for your kind help in advance.

Kind Regards

Hi @winningvish

Based on the condition

Use build datatable

Use add data row


Hi @AshwinS2,

Thank you for your quick reply.

Would you please more elaborate.

Attached workflow: Main.xaml (7.0 KB)