harpscardiff,

You can use the same formula to give you the 10,8,4,3,2,1 in a column
next to each criteria if that is what you are asking:

Just update the 3 to 6, then you will need another level of IF for
each of the criteria....
.... so If(Rank("x","y:z")=6,1
If(Rank("x","y:z")=5,2
If(Rank("x","y:z")=4,3 ETC

I think I have understood your change, but it is a little unclear.

You can then use the "1st" "2nd" & "3rd" on a table that sums what you
need. I don't think I understand why you would need the Min, Median
and Max element.

If I have not given you what you need then perhaps you can provide a
little more detail

Steve