Forum Discussion

Jake_K's avatar
Jake_K
Copper Contributor
Jan 28, 2019
Solved

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 inst...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 28, 2019

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 28, 2019

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

  • Jake_K's avatar
    Jake_K
    Copper Contributor
    Jan 28, 2019

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

Resources