Home > Excel Tutorial > Excel Vba :Finding The Sum Of Unique Elements In A Range

Excel Vba :Finding The Sum Of Unique Elements In A 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 :

sum unique items in column

Macro 2 In The Example2 Sheet :

excel subtotal macro

Download Template

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: