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) attached to each one, to accommodate for any misspellings. Is there a formula that can calculate how many times the name/number appears? Like, 34678 shows up 34 times in Column A, and the result is put into another table/sheet, or just displayed after setting the formula into a cell? The goal is just that, quickly identify how many times it repeats.
Thanks!
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.
