how to combine duplicate rows and sum the values 3 column in excel

by

this one uses Remove Duplicates:

Sub dupremove()
Dim ws As Worksheet
Dim lastrow As Long

Set ws = Sheets("Sheet1") ' Change to your sheet

With ws
    lastrow = .Range("A" & .Rows.Count).End(xlUp).Row
    With .Range("B2:C" & lastrow)
        .Offset(, 4).FormulaR1C1 = "=SUMIF(C1,RC1,C[-4])"
        .Offset(, 4).Value = .Offset(, 4).Value
    End With
    With .Range("A1:A" & lastrow)
        .Offset(, 4).Value.Value = .Value
    End with
    .Range("E1:G" & lastrow).RemoveDuplicates 1, xlYes

End With

End Sub

More Related Contents:

  1. VBA array sort function?
  2. Creating an Array from a Range in VBA
  3. How to find if an array contains a string [duplicate]
  4. How do I slice an array in Excel VBA?
  5. Sorting a multidimensionnal array in VBA
  6. How do I set up a “jagged array” in VBA?
  7. Matching values in string array
  8. How to find a duplicate element in an array of shuffled consecutive integers?
  9. Declare and Initialize String Array in VBA
  10. Deleting Elements in an Array if Element is a Certain value VBA
  11. Is it possible to fill an array with row numbers which match a certain criteria without looping?
  12. How to automatically input an array formula as string with more than 255 characters in length into an excel cell using VBA?
  13. Return Index of an Element in an Array Excel VBA
  14. Writing an array to a range. Only getting first value of array
  15. Excel VBA: Range to String Array in 1 step
  16. Faster way of using Sumifs()
  17. Turn Excel range into VBA string
  18. Get values from union of non-contiguous ranges into array with VBA with a simple command (no loops)
  19. Subscript out of range error with an array – no idea why?
  20. VBA Excel large data manipulation taking forever
  21. Performance difference between looping range vs looping array
  22. Populating VBA dynamic arrays
  23. Dynamically Dimensioning A VBA Array?
  24. Create Chart from Array data and not range
  25. VBA – Returning array from Property Get
  26. How do I Merge two Arrays in VBA?
  27. Excel VBA Quickest way to sort an array of numbers in descending order?
  28. Simple VBA array join not working
  29. Excel VBA – How to Redim a 2D array?
  30. ReDim Preserve “Subscript Out of Range”

Leave a Comment