How would I count the number of occurrences of a name from a list?

So I've got a list of names, many of which are duplicates.

What i'd like to do is to first:

-From the main list, create a second column of unique names with all the duplicates removed

-Have a 'count list which counts how many times each name has occurred.

Like this, but when you populate the Primary column it automatically filters the data for Unique values and Count.

Excel has the 'advanced' feature that can do this, but I'm struggling to duplicate this on Smartsheets.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!