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!

Please post a small sample sheet showing data and expected results. Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Cross posted without links at excelguru.ca
Please add ALL links to identical posts in other forums. Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post