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.