Friday, September 21, 2012

yogi_Create A LeaderBoard Showing Names Of Students And Their Total Scores From Multiple Tests In Descending Order

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #770  Sep 21, 2012

user leedsu said: (!category-topic/docs/spreadsheets/_YYNqLU2Cy4)
Sort, filter and add using unique values in Google spreadheet
Hi there,

new to Google spreadsheets, so any help would be a great help. I have 2 columns - column A: student names who have submitted a test score and column B: the score for test submission. I want to create a leaderboard based on the scores so I would like to:
  1. search for unique names in the first column (and exclude any blank rows)
  2. add the total scores for each unique name
  3. sort by descending order of total scores
.... sure thing. to give it context
  1. I have students submitting multiple online tests via google forms. 
  2. I import the scores from multiple spreadsheets into one google spreadsheet. 
  3. The rows in the example spreadsheet show the format (name, score, & and grade) using sample data from 3 separate dummy tests.
  4. The number of students who submit each test may vary.
What I would like to do is to create a leaderboard of student scores based on the total of their individual submitted scores. So, I need to:
  1. Find the unique names from column A and add their accumulated score from each row where their name occurs. This is the sum of all their different test submissions (they will only enter each test once)
  2. Display each unique name and accumulated score arranged by descending order  

following is a solution to the problem