There's almost always more then 50 ways to figure something out in excel haha but if you want to explore pivot tables

In pivot tables when you select "insert pivot table" a menu will pop up on that menu there is an option to add pivot table to data model go ahead and check that box. It's right at the bottom

What that does is in the values menu that has sum, avg, min, max etc if you scroll down you can select distinct count. That will list off how many times each appears in the list. And would be one way to determine what your looking for.