Question

how to extract unique values from a column in excel

  • 8 February 2022
  • 3 replies
  • 386 views
A
how to extract unique values from a column in excel

3 replies

A

thank you so much

Tamil Arasu10
Rank
Userlevel 5
Badge +11

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!

 

 

 

 

_Tamil_
Tamil Arasu10
Rank
Userlevel 5
Badge +11

You're welcome!

_Tamil_

Reply


Terms & ConditionsCookie settings