We had a group of people write the titles of their favorite songs, and we have about 200 entries - many are duplicates. I can sort alphabetically, and I can subtotal to see how many votes each song got, but how can I display the data so that the songs are arranged by number of votes received? (song with the most votes first, next highest number of votes second, etc.) Thanks for your help! Pat

Hi
perhaps consider using a Pivot Table ?

You could start here, and there are links to the things you can achieve

__________________
Using O365 v2503 - 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