Hi,

I can't help thinking that your analysis would be greatly simplified if your data was arranged in a more methodical way. i.e. as a straightforward table matrix. The Scores Sheet and Summary Sheet seem in any case to be simply different presentations of the same information.

With a simple table matrix you also open up the very powerful analysis that Pivot Tables will give you.

Regards