Formula for Weighted Share Based on Ranking

[cheryll]

I am looking for a formula for "Weighted Share Based on Ranking". Any help would be appreciated. Thanks!

Doctor	Ranking	Weighted Share Based on Ranking
Smith	1	1.05
Jones	2	1
Johnson	3	.95

<tbody>
</tbody>

 

[Joe4]

Welcome to the Board!

What exactly are you trying to weight?
It would be helpful if you showed us a small sample of the data you are trying to weight and the expected outcome.

 

[cheryll]

Welcome to the Board!

What exactly are you trying to weight?
It would be helpful if you showed us a small sample of the data you are trying to weight and the expected outcome.

It's not really weighted. The share I need to assign is strictly based on the ranking (as in the example). Each "share" is assigned a dollar value, then physicians get more or less than one share based on different ranking criteria. I just need a formula for that third column. Thanks!

 

[Joe4]

If your rankings are in cells B2:B4, then you can get the numbers in the third column by placing this formula in C2 and copying down to C4:

=1.1-(B2*0.05)

 

[cheryll]

If your rankings are in cells B2:B4, then you can get the numbers in the third column by placing this formula in C2 and copying down to C4:

=1.1-(B2*0.05)

Actually had to modify formula to =1.4-(B2*0.05) as I have 15 lines, but it worked! Thank you!