Sum of all Repeated values in Excel

Hi,

I Have one data in Excel.
I want to get sum of all repeated value and paste in another sheet.
Example: sheet1 value:
A 10
A 10
A 10
B 20
C 30
C 30
result In another sheet Should be
A 30 (Sum of all repeated value)
B 20
C 50 (Sum of all repeated Value)

Hi @Amarjeet566,
It may helps you.

Regards
Balamurugan

Main.xaml (16.9 KB)
Refer this File,It may helps you.

Hi,

I am not able to find this package. Can you please help?

Thanks
Vasudhara

It is linked in the reply from @balupad14 who is the creator of that custom activity

Hello @Dave,

You can get it here.

https://go.uipath.com/component/datatable-related-activities

Regards
Balamurugan.S

1 Like