Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 10 Ranking | Excel Discussion (Misc queries) | |||
Ranking | Excel Worksheet Functions | |||
ranking over a sum | Excel Worksheet Functions | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) |