Question

how to extract unique values from a column in excel

  • 8 February 2022
  • 3 replies
  • 28 views

how to extract unique values from a column in excel

3 replies

thank you so much

Userlevel 3
Badge +7

Hi @Adityaganesh Srinivasan​ ,

 

Please refer these links to develop your logic:

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-example-transferring-data-from-text-file-to-excel-worksheet.html

https://docs.automationanywhere.com/bundle/enterprise-v11.3/page/enterprise/topics/aae-client/bot-creator/commands/example-extracting-data-from-excel-to-a-webform.html

 

  • You can use excel as a database and create the query to get unique value
  • You can pass the excel formula using the Excel Advanced Package to get the unique value.

 

 

Thanks!

 

 

 

 

Userlevel 3
Badge +7

You're welcome!

Reply