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!

Related Conversations