@jsegura 2409  this article will help you - https://www.ablebits.com/office-addins-blog/excel-unique-distinct-values/

Thanks, but it doesn’t help at all :(

How could I apply that in Automation Anywhere?

This is possible if we use loop and if condition.

If column value Present in list then delete current row

Else add column value to list.

If you have large number of data then you should go with Excel as db

Thanks,

Aravindh s

Aravindhkumar002@gmail.com 

Hi,

I don’t have a large number of data and also don’t want to delete any values in the current row. 

I don’t really understand the syntax on how to achieve this.

Thanks