Group by 1 excel column and add values in another excel column

I have an excel file with 3 columns 1 containing the name of the person, 2nd column the "State" and third column containing the persons expenditure. I want to group by the person and state and sum all the expenditure values and save the name, state and summed up value into a new excel sheet.


  • edited December 2018

    Hi Jamnanin,
    Record a macro in Excel for creating a Summarized Pivot table into a new Worksheet and use 'Run Excel Macro' command in Automation Anywhere to call the recorded macro.

    Note: In the macro, modify the code to make a dynamic selection of cells range.

Sign In or Register to comment.