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:
Is there a formula that can automate populating names and the count without having to input each name manually?
View best response
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!