ranking unique values with cumulative values

[hartjonathand]

hey guys,

I think I have a low end solution but for bigger projects I need the following

I want to put the rank in column A. In column B I have tenant names in text formats. In column C I have the size of their space. Many of the tenants have multiple spaces, I want to be able to rank based on unique text values, so if the tenant name appears more than 1 time the rank value does not change and is based on the total summed value for all that tenants space.

I hope you guys can help

for example

[TABLE="width: 292"]
<colgroup><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Rank[/TD]
[TD]Suite[/TD]
[TD]TenantName[/TD]
[TD]SF[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD]Bob Jones[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2[/TD]
[TD]James[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3[/TD]
[TD]Bob Jones[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4[/TD]
[TD]Jameson Wells[/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]

 

[hartjonathand]

I see I got this answered already sufficiently. Thank you

 

[63falcondude]

I see I got this answered already sufficiently. Thank you

Can you share the link where you got it solved?

 

[hartjonathand]

http://www.mrexcel.com/forum/excel-questions/942958-duplicate-values-sum-rank-value-ordering.html


this partially works, I expanded on it some. It should work.