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

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?

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

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.”

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.


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