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!