Ranking and Movement

[John]

I am trying to track my music from I - Tunes. I want to see what i have been
listening to each week. So each week I copy all my music and paste them into
Excel. I copy the Artist, Song, Genre, and Times played. I want to see how
songs move, and want to see if there are formulas i can write too see how
many times a song was played in a certain week and then list the top 10 songs
played in that week. Now I know that i can reset my song count in I- Tunes
but i want that to keep going. I have over 2000 songs so it would be hard to
find it on a list. I copy each list next to each other. So colums A-d would
be song, Artist, Genre and times played in week one. Then Colums E-H would
be the same thing for week two. This is something i am doing for fun, so I
am open to copy them into differnt formats or locaitons in Excel. Any help
in formulas or places to look on the web would be great. Thanks in advance.

 

[Joel]

It looks like you have the number of times already on the worksheet. So if
you do a sort of columns A-D and use the number of times played as the sort
key then you will have the results you are looking for. Sort is in the
spreadsheet menu under DATA - Sort.