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	5594	September 1, 2021
Remove duplicate rows based on identical values in two columns Studio	2	3014	September 10, 2020
How remove duplicate name or data in row Help excel , activities , question	14	1829	March 30, 2020
DataTable - Remove Duplicate Row Help datatable , excel , activities , question	11	9366	December 1, 2019
Remove Duplicate rows based on single column and that too if cell starts with specific values Activities excel , activities , question	22	876	October 12, 2023