how to rank multiple values in single column according to how often value is duplicated

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!

The function is fairly easy. It is a sorted histogram. Attach your file, I will set this up and re-attach it for you.

wow - that would be great. Unfortunately I am unable to upload, so I have uploaded it to google docs here. Pls let me know if you are able to retrieve the spreadsheet OK. Many thanks!

Thank you so much for your help! I am looking at it now and completely understand your approach. the challenge is of course in determining how many times we encounter a cluster of 9, 8, 7,...3,2 duplicates and then to allocate the cells accordingly (C1-C3). Your example took care of this nicely because it is dealing with a known and an easily manageable number of recurring items. In my list of jpg-names however, there will be several hundreds of clusters with say, 9 duplicates, 8, 7 etc. - Perhaps there is a way to just count the entire column returning how many duplicate-clusters exist and in a second step highlight and sort these duplicate clusters according to number of duplicates in each one of them...

I just saw your update - does that solve my problem? I am experimenting now myself with your instructions...

great! thanks a lot - this worked perfectly - as a last step I just sorted the columns as a table and got the perfect result. Brilliant!