•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Best way to tally in 1 sheet to another
I am new to excel and i want to make tallying more easy and efficient. Is there any formula or tips for me to do this type of tallying :
Example:
I have sheet 1. And column A is about different words said by random people (this column is an ongoing survey for a year)
In sheet 2, there is a table where i need to know how many times that specific word appeared in column A. And i want it to automatically be tallied already from sheet 1
Is there a way for me to make a formula out of it? Thank you!!!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#rows.com
#Excel
#tallying
#formula
#sheet
#column A
#data
#survey
#automatic tally
#words
#efficiency
#count
#table