Monday, August 22, 2016

Excel Finding The Sum Of Unique Elements In A Selected Range


In this study, we have worksheet that it has 9 columns .

We created  a VBA code to sum the values of unique elements in column "B". Ago we listed items in column "B" as unique elements  into column "K" . Later  we entered the total of these items into column "L".

For this purpose we created different two macros.

Macro 1 In The Example1 Sheet :


Macro 2 In The Example2 Sheet :