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.



    Regards,
    Sri

Participate now!

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