SOLVED
Home

Pulling last name data into a new sheet in order to count the occurrences

Jake_K
New Contributor

Hello all,

 

I am attempting to make a new worksheet that pulls last names from another worksheet and keeps a running count of how many times that last name appears in the other worksheet. For instance:

 

Albert3
Gerrity8
Miller2
Nathanson4
Saleh1
Rudd9
Zymanski5

 

Is there a formula that can automate populating names and the count without having to input each name manually?

2 Replies
Highlighted
Solution

If your last names are in separate column the Pivot Table will be the easiest way

Thanks! That did the trick and was easier than expected!