Find the Duplicates in Excel

Learning Initatives Automation Starter
1

Journal_Number|Transaction_Reference
1234 | Yogita
5678 | Minal
9101 | Nikhil
1122 | Akshay
1345 | Minal

above are the two excel column find the duplicate from Transaction_Reference column and i want output below then send mail duplicate find

Journal_Number Transaction_Reference

                5678       |  Minal 
                1345       |  Minal

and also if excel is empty code still running

2

Hello Yogita,

For your first point regarding duplicates you can easily use “Remove duplicate activity” which will help you remove duplicates.

Second, if you are using for each activity make sure you have cross checked your sequences.

Thanks & Regards
Sonam Nath