Skip to main content
how to extract unique values from a column in excel

thank you so much

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!

 

 

 

 

You're welcome!

Reply


Terms & ConditionsCookie settings