Add How Many Names Appear in Column Without Using A Formula Using a Specific Name
I need to track first aid statistics to determine how many employees are responsible for first aid incidents, per month, per location. We have 275 employees and any of those names can appear in the spreadsheet during the year so I don't want to create a formula that will contain that many names. I want to pull information from the original sheet into a separate reference sheet. For example, taking the simplified information from below, how can I show that in December - 3 employees were involved in 4 incidents in Location A, 2 employees were involved in 4 incidents in Location B and 4 employees were involved in 4 incidents in Location C?
Help Article Resources
Check out the Formula Handbook template!