I want to filter the excel based on column values

Hi
I want to filter the excel suppose in the column name its having the value A,A,B,B,B,C,C,C,D,D in another column name it having its A–>success,B–>success, C—>sucess,D—>suCcess i want A as single occurance B has single occurence and simlarly c&d and its success count

thanks

Hi @FASupport21_Praveen_Kumar finally u want like this

A,B,C,D is it right?

If it is yes, then use remove duplicate row activitiy

Check it Link of documentation : https://docs.uipath.com/activities/docs/remove-duplicate-rows

Hope it helps you

Mark it as solution if you got it

Regards,

Nived N :robot:

Happy Automation :slight_smile: :slight_smile: