Hi, I work for a large DJ company and need to compile a 'Most Popular' list of the tracks we play each month. Every week approx. 20 playlists are submitted by DJs around the country to our database. Each playlist contains about 80-100 artist and song titles. These playlists are submitted as .txt files. I'm aware that I can copy all these files into one .txt file and then open this in Excel. I have to clean the data a little at this point but I can get a long list of Artists in the first column and the respective song titles in the second column. I know to link both columns and sort by 'Artists' first and then 'Song title' second so all the Artist and Song cells stay together.

Unfortunately this is as far as my knowledge will allow me to get.

What I need to be able to do is compile a Top 200 list of the most popular tracks. Is there a way to get Excel to count up all the duplicate song titles in my spreadsheet, add the number of duplicate tracks into a third column and then sort my list numerically from highest to lowest give me the most popular tracks.

Thank-you in advance. I'm using Excel 2008 on Mac.