Hi guys! I am doing this Excel trend tracking project but got stuck at one point and really need your help!! Thanks in advance!
So I collected students' trial tests scores from classes in one year. I input all the data into excel already. so in column A, i put ClassA-E; in column B, each class has rows labeled students No.1-10. Then starting from columnC are all the trial scores spread out horizontally.
Trial 1 Trial 2 Trial 3
Student 1 30 22 30
Student 2 34 26 34
C Student 3 38 30 38
L Student 4 42 34 42
A Student 5 46 38 46
S Student 6 50 42 50
S Student 7 54 46 54
Student 8 58 50 58
A Student 9 62 54 62
Student 10 66 58 66
So if I only want data(scores) of student10 from classA, which formulas/whatever works should i use to retrieve the data from my database? I am thinking about having buttons/dropsown list on the class and student number selections, to specify my criteria.
Thank you so much for your help!! I'd really appreciate any idea!!
Bookmarks