Hi People,

Basically I have been asked to find out the difference in scores between male and female test participants and display the results in a table.

I would much prefer to use a formula to draw from the data and calculate an output then have to manually do it, as this would be very time consuming and prone to human error.

Participants can score between 1-9 in whole number increments. I have a column (F) stating the gender of each participant. This is identified by a capital F or M (Female, Male)

Column J displays the results of the test with a range of 1-9. For example, 1, 3, 5 , 9 etc

In a separate table, I would like to display how many males scored 1. On the next row, how many males scored 2 etc.

I want to then repeat this for females.

Any ideas?

Thanks