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!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Doctor
[/TD]
[TD]Ranking[/TD]
[TD]Weighted Share Based on Ranking[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD]1[/TD]
[TD]1.05[/TD]
[/TR]
[TR]
[TD]Jones[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD]3[/TD]
[TD].95[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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!