Duplicate entries in excel

Maintain a list of already actioned items, check if current item is already actioned and skip the iteration.

Loop each row in excel
 if current item exist in actioned items
 continue
.
… other processing steps
.
add current item to actioned list
end excel loop

Hi Sumit,

Thanks for your reply. I have to pick up records one by one from one excel and match them from the other excel, so how can i already prepare a list of actioned items beforehand. The continuing of the loop has to be on the fly if it finds a duplicate.

Hello, 

Step 1, Use Excel Advance: Get multiple cells , and assign the value to a “Table” Variable; 

Step 2, Use Data Table: Remove Duplicate Rows, to remove the duplicate rows in that “Table” Variable;

tips:

you may also need to count the rows of the “Table” after step2, to get the actual distinct number or rows for the “Table” variable, which count can be used in next Loop step to Find the matching rows in the second Excel file.