Clipboard fo 9 G HKLMNOPQ R S T CI 1) Create a pivot table like the one below 1 2) make sure you use conditional formatting Z Name Grade Score 3 Fredi F 64 4 Fred2 B 86 Grade # of Students % of Students 5 Freda A 94 A 5 25% 6 Freda F 63 B 3 15% 7 Freds D 67 2 10% 8 Fred A 90 30% 9 Fred7 70 4 20% 10 Freds F D 67 11 Fred D 67 12 Fred 10 A 94 13 Fred11 F 63 14 Fredi2 F 60 15 Fred13 D 66 16 Fred14 98 17 Fred15 D 65 18 Fred16 A 91 19 Fred17 D 68 20 Fred18 71 Pivottable 21 Fred19 B 82 Click in this area to work with the 22 Fred20 B 86 Pivottable report 010 011 Q12 013 014 015 0.16 017 Q18 Q.19 Q20 Q21 Q22 OOOO Q Type here to search S e