Thanks ixlat0, but that only comes up with the total score, I actually need each individual score as I convert the scores from each column to try and standardise them and then use a certain percentage of that score depending on the race distance, hope this makes sense. Shaun , if you can tell me how to just get the bottom table i would be grateful.