Question

Extracting unique values from an Excel colum

  • 24 July 2023
  • 4 replies
  • 101 views

Badge +4

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


4 replies

Userlevel 5
Badge +10

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

Badge +4

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

 

How could I apply that in Automation Anywhere?

Badge +3

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 

 

Badge +4

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

Reply