Jan 28 2019 08:45 AM
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:
Albert | 3 |
Gerrity | 8 |
Miller | 2 |
Nathanson | 4 |
Saleh | 1 |
Rudd | 9 |
Zymanski | 5 |
Is there a formula that can automate populating names and the count without having to input each name manually?
Jan 28 2019 11:14 AM
SolutionIf your last names are in separate column the Pivot Table will be the easiest way
Jan 28 2019 12:18 PM
Thanks! That did the trick and was easier than expected!
Jan 28 2019 11:14 AM
SolutionIf your last names are in separate column the Pivot Table will be the easiest way