SOLVED
Home

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

Highlighted
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
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies