How to remove uplicate rows from excel by considering the text case

Help Studio
,
1

Hello guys…
I have removed the duplicate rows from excel by using the “Remove Duplicate Rows” activity. But still there are some duplications because of the case sensitivity. So, I am not able to solve this problem. Can you please help me?

2

If you place the data in a datatable you can use Filter DataTable as an alternative

3

Ok ronanpeter I’ll try this & will inform you…Thanx for the quick reply