1 min readfrom 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!!!

submitted by /u/ArrivalRight194
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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