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!

​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!  Read More

​