Question

Extracting unique values from an Excel colum

Is there a way to extract unique values from a column in Excel that don’t involve using Excel as a Database?

Userlevel 5

+14

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

Sign up