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)