VBA Code: sum the values based on unique values

  • Hi,
    Please find the attached sample data file and I am looking for sample VBA code for below scenario.

    My result should display in Column D and I need a sum of values in ColumnB which should come from unique combination of ColumnA and ColumnB.

    Example from data file: My result ( ColumnD), For the combination of "AM02" (ColumnA) and "disp_AC_In" (ColumnC) should be 350.

    I hope you understood my scenario. Please let me know if you require more details to understand my scenario.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!