Skip to main content
Question

Extracting unique values from an Excel colum


Forum|alt.badge.img+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

rbkadiyam
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • 582 replies
  • July 24, 2023

Forum|alt.badge.img+4
  • Author
  • Cadet | Tier 2
  • 8 replies
  • July 25, 2023

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

 

How could I apply that in Automation Anywhere?


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 20 replies
  • July 25, 2023

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 

 


Forum|alt.badge.img+4
  • Author
  • Cadet | Tier 2
  • 8 replies
  • August 3, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings