I have for categories example A,B,C & D and have 24 questions each with 4 possible answers.
When taking the survey I am only allowed to select one answer from the possible four answers for each question.
Each of the 4 possible answers is mapped back to one of the four categories.
Based on your answers selected I would like to calculate your highest category (#answers grouped by category)