Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #770 Sep 21, 2012 www.energyefficientbuild.com.
user leedsu said: (http://productforums.google.com/forum/?zx=vay6zqqzi38u#!category-topic/docs/spreadsheets/_YYNqLU2Cy4)
Sort, filter and add using unique values in Google spreadheet
Hi there,
---------------------------------------------------------------------------------
following is a solution to the problem
user leedsu said: (http://productforums.google.com/forum/?zx=vay6zqqzi38u#!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:
- search for unique names in the first column (and exclude any blank rows)
- add the total scores for each unique name
- sort by descending order of total scores
Thanks!
----
.... sure thing. to give it context
- I have students submitting multiple online tests via google forms.
- I import the scores from multiple spreadsheets into one google spreadsheet.
- The rows in the example spreadsheet show the format (name, score, & and grade) using sample data from 3 separate dummy tests.
- 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:
- 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)
- Display each unique name and accumulated score arranged by descending order
---------------------------------------------------------------------------------
following is a solution to the problem
