I have received a spreadsheet containing 30 funds. Each has a score for 4 different fields (performance, liquidity, riskiness and dislocation), they have then been placed in rank by the person I was sent the spreadsheet by. Hence each field must have been given a weighting to give the correct ranking. I have been placing weightings on each field to try and replicate the rankings, however I was wondering whether there is a more exact way using Excel?

Any help would be greatly appreciated!