Forum Discussion

Jake_K's avatar
Jake_K
Copper Contributor
Jan 28, 2019

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

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?

  • If your last names are in separate column the Pivot Table will be the easiest way

  • If your last names are in separate column the Pivot Table will be the easiest way

    • Jake_K's avatar
      Jake_K
      Copper Contributor

      Thanks! That did the trick and was easier than expected!

Resources