If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Learn how to count the number of words in Microsoft Excel. Use this Function to get the word count easily - with or without spaces.