I have a list of websites and what I am trying to do is return the item that has the most duplicates, then the second most, then the third, and so on, into a separate column.

There are several items that tie for the amount of duplicates. In that case, I would just like it to just display those in any order. Example: I have one site that shows up 5 times. I would like to display that one first. Then there are 4 sites that show up 4 times, those can go in any order. The sites that shows up 3 times should be in 6th place, and so on.



I have tried the rank function, the product sum, vlookup with max...I can't figure it out! HELP!