Excel Hack 45: Count number of unique values in a list in Excel
MS Excel has a =COUNT function for counting the number of items in a range, and even a =COUNTIF function for counting specific items in a range. But how about a function to count the number of actual items or values in a list? This is a short post on how to set up a