Hi,

First of all, I am a novice in Excel. I don't even know if I'm posting in the right thread.

I'm organising a quiz tournament for pairs. In stead of randomly pairing each quizzer, I'd like to do these on the basis of their strengths. For example, someone who isn't strong in sports will be paired with someone who is.

Before the tournament I will let everybody fill in a list in which they rank their strengths in the following 9 categories: sports, geography, history, music, biology, science, literature, art and film. You give 9 points for your strongest subject and 1 point for your weakest.

On the basis of these lists I would like the programme to divide the whole field into the pairs that are the most complementary.

Is this possible? Is this hard? Does this type of programme already exist?

Thanks for all the help!