I have a bot capturing log report from orchestrator. I need to filter the excel file to remove duplicates. The bot should only check for duplicates in the “Message column” and should delete that particular row if there is any. Someone please help me with a fix to do this.[image]

Remove duplicates from excel considering specific columns

ppr (Peter Preuss) June 12, 2020, 11:05pm 3

@Teny_Joy
Have a Look Here

In this Demo File some scenarios are Show cased and one is implementing your case

Topic		Replies	Views
Remove duplicate rows based on specific columns? Studio question	8	5110	September 1, 2021
Remove duplicate rows based on identical values in two columns Studio	2	2957	September 10, 2020
How remove duplicate name or data in row Help excel , activities , question	14	1665	March 30, 2020
DataTable - Remove Duplicate Row Help datatable , excel , activities , question	11	8990	December 1, 2019
Remove Duplicate rows based on single column and that too if cell starts with specific values Activities excel , activities , question	22	789	October 12, 2023