•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Return the count of all words in a column
Is there a way to take a column and use a spill formula to return in the next two columns A) the words the column consists of and B) the count that the word appears in from the column?
background: I have a spreadsheet where column A is the survey ID and B has the written responses from the survey. I want to take column B and make a formula that returns the count of every word from column B. I am likely going to remove common words like the or he she etc so it runs better.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#column
#word
#count