Best way to quantify data

[Catherinefsimon]

Hello,
I am completely stuck on how to tally the following data.
Each subject is quizzed on memorizing colored letters in two different scenarios. I need to see (maybe in a pivot table but charts could be great too), which letters are most often incorrect and what they are mistaken for. If not possible, I can do without having the color recorded. Any ideas?

<table style="border-collapse: collapse; width: 400pt;" width="533" border="0" cellpadding="0" cellspacing="0"><col style="width: 40pt;" width="53"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 24pt;" width="32"> <col style="width: 48pt;" span="5" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 40pt;" width="53" height="20">Subject</td> <td class="xl66" style="width: 48pt;" width="64">Version</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Handicap</td> <td class="xl66" style="width: 24pt;" width="32">A/N</td> <td class="xl68" style="width: 48pt;" width="64">Color</td> <td class="xl65" style="width: 48pt;" width="64">Correct</td> <td class="xl66" style="width: 48pt;" width="64">Incorrect</td> <td class="xl69" style="width: 48pt;" width="64">Actual</td> <td class="xl69" style="width: 48pt;" width="64">Skipped</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Red</td> <td>P </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Red</td> <td>H </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Red</td> <td>V </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Red</td> <td>C </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Red</td> <td>
</td> <td>
</td> <td>
</td> <td>T</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Blue</td> <td>
</td> <td>O</td> <td>D </td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Blue</td> <td>A </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Blue</td> <td>O </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Blue</td> <td>
</td> <td>R</td> <td>F </td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Blue</td> <td>N </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Green</td> <td>E </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Green</td> <td>G </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Green</td> <td>N </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Green</td> <td>
</td> <td>O</td> <td>D </td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OS</td> <td>20/50</td> <td>A</td> <td>Green</td> <td>H </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Yellow</td> <td>O </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Yellow</td> <td>F </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Yellow</td> <td>L </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Yellow</td> <td>C </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Yellow</td> <td>T </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Orange</td> <td>A </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Orange</td> <td>
</td> <td>F</td> <td>P </td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Orange</td> <td>E </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Orange</td> <td>O </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Orange</td> <td>T </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Purple</td> <td>T </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Purple</td> <td>Z </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Purple</td> <td>V </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Purple</td> <td>E </td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Purple</td> <td>
</td> <td>O</td> <td>C </td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> <td>OD</td> <td>20/20</td> <td>N</td> <td>Purple</td> <td>L </td> <td>
</td> <td>C</td> <td>
</td> </tr> </tbody></table>

 

[bk]

If you just mean the text description of the color, you're saying that a CountIF, SumIF won't get you to the solution you want?

You mentioned Pivot Tables; so, I assume you're familiar with those formulas I mentioned.