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