I have a single column with almost 10,000 numerical file-names (pls see screenshot here). They represent image-names collated together from several sub-folders. As you can see I have already highlighted the duplicates. However, my objective is now to rank the duplicate image-names according to how many times they are duplicated. In other words, I would like to sort/rank the cluster of the highest number of duplicates first and so on, instead of the colored clusters of duplicates being all mixed up. So, in the attached screenshot, the 5 duplicates currently showing in cells A9533-A9537 should rank above the 3 duplicates currently showing in cells A9524-A9526 and A9528-A9530; and the clusters of 3 duplicates should of course be ranked above the duplicate clusters of twos...

I am a medium skilled Excel user and am hoping that this is even possible.

Thanks a lot in advance!