Oh that's bad.
Could you post some function?

My data range is A1:K8.
A1:A8 or 1st column is just name of data
1st row is just rank which one should be high contribution to rank between 1-10
B2:K2 is just name of each column
Actual numeric data range is B3:K8 in excel sheet.

So, I hope now you can do this