Search results

  1. A

    Averages for Duplicate Cells

    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...
  2. A

    Find the Median???

    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.
  3. A

    Is this even possible??

    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...
Back
Top Bottom