I have a list of values in column A. Some of the values occur once, some occur twice, some occur more than 2 times. In column C, I would like to only list the values from column A that are repeated more than once, and I would like to sort them from highest to lowest by number of occurrences.
I was able to develop a formula that lists the duplicates, and I can easily use CountIf to list the number of occurrences. Unfortunately, the formula for listing the duplicates is an array formula, so I can't sort it based on the number of occurrences.
Is there any other solution?