How to get unique data & the totals of selected rows in excel

Automation Studio
1

Hello,

Is it possible to get remove duplicates & get the unique items from a column in an excel? Then, for each unique item, calculate the sum of corresponding cells in the second column. I am including a sample file for reference. In this file, I need unique items from column1 (11000, 12000 etc.) and then calculate the sum of cells in column2 with 11000 in column1, then 12000 and so on.

Thank you!
SampleFile.xlsx (10.7 KB)

2

Hi,

You can use excel recorder activity to achieve your use case

3

can we use LINQ in Assign Activity for Data-table for removing duplicates and get distinct records in AssistEdge RPA studio?

4

Hi,

Assign activity will accept VB .net command