I’m currently automating a payment process. The user says he will be giving the input in an Excel file.
He wants to use the same file forever, since he wants to look for duplicates in four columns and remark as “Skipped”.
If values in two columns matches, I should remark as “Recheck”
If values in one column matches, I should remark as “Duplicate”
Please refer the attached Excel file for better understanding.
INPUT.xlsx (10.3 KB)
“TransactionData” is the output of the Excel Read Range. I use these expressions to take the entries with blank remarks.
Then look for duplicates and add the required remarks.
If there’s a success remark, it becomes blank. I should add remarks only to the cells which is blank. But need to look for duplicates in the whole excel file.
Please help me with this.