Formula for highest value

[bakerwe3]

Hi

I would like a formula that allocates 10 point to highest bidder, the second bidder get proportion of the 10 point as distance from the highest bidder, so same from bidder 3 etc.

Hope the above makes sense

Any help would be much appreciated

Thank you

 

[steve the fish]

Lets say you have some values in A1:A10. Put this in B1 and drag down:

=A1/MAX($A$1:$A$10)*10

Is that what you mean??

 

[bakerwe3]

Perfect! Why was that so hard for to figure out, must be thinking on this to hard.