I am trying to count how many times the names of all employees shows up on this worksheet. However, I do not want to have to do a
COUNTIF for every single employee as this would take far too long.
What I would like is two columns, the first with the name of each employee listed and the 2nd with the number of times their name occurs in said sheet. Their names will also only be in one column so the formula does not need to scan the entire sheet.
Is there a way for Excel to do this for me?