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.
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.
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”.