Fetching duplicate values from specific column and coping it to another excel sheet

[Elle_R]

Hi all,
Need a kind help,
How to check whether there are any duplicate numbers from respective column. and If there are duplicates then copy that row to next sheet in the same excel.

any suggestions?

[ceyda_eren]

Hi Welcome
Remove Duplicate Rows you can use this activity
Can you send sample excel?

[Elle_R]

Hi thanks for response…

Not allowing to attach file… showing error “Sorry, new users can not upload attachments.
Read more here on how to easily remove this restriction.”

[omer.ozturk (Ömer Öztürk)]

Hi @Elle_R,

You can check this topic. How to get duplicate rows for specific column in a datatable - #3 by arivu96

I guess it solves your question.

Regards.
Ömer

[ceyda_eren]

If the Remove duplicate activity is not enough, you can also follow this process.

Find the duplicate rows based on one column name and move to a different Datatable

Hi Team, Need help in the below scenario. I have gone through all the help topics and could find an exact solution for the scenario. My scenario is, I need to find the duplicate rows in the main datatable based on the “Subject” column and the keeping the 1st occurrences and other non-duplicates in the main datatable and move all the duplicates to another new datatable. Main Datatable: [image] New Duplicate Datatable should look like this: [image] So once we moved the duplicate to the new …