Forum Discussion
Formula Help for a tally
Looking for quick help creating a formula. What I'm working with is going to be a long table with up to 30 names that'll be repeating often. They can also have a specific number (employee number) ...
I'd create a pivot table based on the data.
Add the employee number to the Rows area and also to the Values area of the pivot table. If necessary, change the summary function of the value field to Count.
See Excel Pivot Tables if you're not familiar with them.