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

Rank	Suite	TenantName	SF
	1	Bob Jones	10
	2	James	20
	3	Bob Jones	50
	4	Jameson Wells	100

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

 

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