EXCEL VBA CODE TO SUM UNIQUE VALUES

In the video ,you can see with Excel VBA codes how to sum and list the unique values in worksheet .
For example, we processed on the cells in column B and their numerical values in column I.
In the Example2 sheet, we found the sum of the unique values using VBA subtotal method :
"Sheets("Example2").UsedRange.Select
Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(9), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
Application.DisplayAlerts = True"

Visit for example workbook : [ Ссылка ]

свернуть