Currently Being ModeratedJan 18, 2013 11:24 AM (in response to jcrowton)
Here's a possible implementation:
You have three calculated columns added to your main record to categorize the results. Data from the AllScores table are then pulled into separate class tables based on the calculations.
=IF(B2>=90, "A", IF(B2>=80, "B", "C"))
=COUNTIF(OFFSET($C$1, 0,0, ROW()), C)
Select these three cells and Fill to the bottom of the table.
=IFERROR(INDEX(AllScores, MATCH("A"&ROW()-1, AllScores :: E, 0), 0), "")
=IFERROR(INDEX(AllScores, MATCH("A"&ROW()-1, AllScores :: E, 0), 2), "")
Select these two cells and Fill to the bottom of the table.
For tables B and C, substitute B or C where you see that letter in quotes in the formula.
Is this what you had in mind?
Currently Being ModeratedJan 18, 2013 11:27 AM (in response to Jerrold Green1)
Ordered by name.
It would be really nice if on the category tables there was a spot for name and score, and then ordered by score.
So Group 1 would have the students name with scores in descending order. For example Josh 98, Alyssa, 96, etc.....
Hopefully that made sense.