This can be done using pivot tables. See this youtube video for a walkthrough: Quickly Count Duplicates in Excel List With Pivot Table.
To count the number of times each item is duplicated in an Excel list, you can use a pivot table, instead of manually creating a list with formulas.