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
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies