Help Ranking
 

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.

Help Ranking
 

COUNTIF() would be good, but we need to know the criteria in advance. Look
into building a Pivot table. You can easily track the frequency of occurance
of items. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200760


"John" wrote:

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.