Search results

blinda! thats perfect mate cheers!:eek: Alex.

Cracker! Cheers Paul

the chart is here: Charts.mdb

yeh that sounds good.. how do I do that?

Right, So i've got a table which has records for the Top 40 Music Charts. I want to be able to find out the averages for each song taken from it's positions in the chart over the weeks: So essentially I get something that tells me [Lenny Kravits] [American Woman] [24.5] [Silverchair] [Ana's...

No, just the median number of the weeks it was in the chart. So for the Foo Fighters - Learn To Fly, They had 6 entries and during that period they were at positions 43,43,38,38,40,32. It should give them a median of 39 Cheers. Alex

Ideas? I know there's a way to get the median somehow :D

Well is more personal research. The attachment was great.. It solved one of my problems. Still need to work out the median for each song. The reason being Britney Spears - Baby One More Time was in the chart 26 times however her placings were fairly low (She was only at Number 1 for four weeks...

Oh wow! ...and i was just getting ready to slam my head in the door Cheers bud.. ill have a play with that alex.

True.. and thats part of what i need to do.. EG, for Cher.. When sorted by Date her median for 'Believe' is 7. Once i get the medians for all the songs, I can then sort them and find the top 40 songs for the entire year. See? Cheers. Alex!

oops! meant to say each artists song according to the "This Week" column..

heres 1999 Ok here is 1999 Charts for New Zealand Top40.. Basically I want the medians for each artists song. Charts.mdb

OK try this: I want to get the Median number from the "This Week" column for Cher. The output should hopefully tell me that Cher has a score of 7. In addition to this.. I want to be able to create a report which tells me the medians for all the artists in the sheet. Any ideas?? Cheers, Alex.

A better explanation: I want to be able to > combine all "STEPS" entries > sum up their weeks in the chart (9 entries) > give them a score by adding up the weeks (ie: 1+2+3+4+5+6+7+8+9 giving them a score of 45) and then displaying this data along with other artists somehow so it could...

Thanks Alastair69... That does kinda work but the problem is ive got thousands of entries and it could take some time to do it manually. But thanks

OK so here we go.. I've got a huge excel sheet which has the Top 40 music charts for every week since 1999. But heres the deal. I need to create a way to sum certain fields and create some sort of ouput... heres what I mean: (A Smaller version of my chart book) I want to be able to find out...