Forum Discussion
Chuck-NY
Aug 05, 2024Brass Contributor
What is the best way to identify the words and the frequency of words in an Excel column?
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.
- Detlef_LewinSilver Contributor
- peiyezhuBronze ContributorPlease provide some data and your expected result.