Group column by name in excel

Hi All,
In the below attached excel file. If vend name is the same from the ‘G’ column then Invc amnt should be added together. the total amount should be added into next column like Vend Total.

The first attached image is the original file. The output should be like second attached image.

Thanks in advance


you can “SUBTOTAL” command in Excel (Alt +X+V) and select the columns and the operations to apply. Insert subtotals in a list of data in a worksheet - Excel (

Or read the worksheet to the data table and elaborate the data to obtain the same result then write all the data table to an Excel worksheet again.

regards, Gio

have a look here for grouping data

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.