I have two coloums, one with gender, and one with subject choice. For the subject choice, there can be multiple answers (i.e. it could be maths, or it could be maths/english/geography), I want to get a comparassion of what subjects each gender choices (including if this is just one of their choices).

I think I'd do this in a pivot table, but I can't get it to work (am kinda new to pivot tables). I'm using excel 2007.