[HW 2.5d] Identifying and Counting Unique Items

In working with lists, it’s very common to have to produce a unique set of items in a range.  This might be useful for summarizing the dataset.  Or, it might be important for reconciling the dataset against some other list.  Or maybe you just need to check for duplicates.

Another aspect of this problem is to be able to count the unique items in a list.

uniques

For this assignment, please do one of the following.  Either:

a) Write a VBA formula to count the unique items in a list.  In the above example, the formula would return the number 10.

–OR–

b) Write a VBA sub that will take a range and produce a unique list of items from that range. In the above example, it would return the column of names under the header “Uniques”.

 

Advertisements

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: