Hi! I need to create a list of the number of times a single word appears in a column. The word may be in multiple rows (of thousands of rows). I’m seeking to discover which words are in the column and how many times (number of rows) a word appears in a column.

I can’t use the IF, because I don’t know the words. I want excel to list the words and the number of times (or rows) in which the word appears.   

Example: My column has 5,000 rows with world city names. It would be too hard to use IF, because I’d have to guess the city name, and there are too many cities in the world to guess. I want Excel to tell me what city names are in the column and how many time the city name appears.  

​Hi! I need to create a list of the number of times a single word appears in a column. The word may be in multiple rows (of thousands of rows). I’m seeking to discover which words are in the column and how many times (number of rows) a word appears in a column.  I can’t use the IF, because I don’t know the words. I want excel to list the words and the number of times (or rows) in which the word appears.    Example: My column has 5,000 rows with world city names. It would be too hard to use IF, because I’d have to guess the city name, and there are too many cities in the world to guess. I want Excel to tell me what city names are in the column and how many time the city name appears.    Read More

​