hartjonathand
New Member
- Joined
- May 23, 2016
- Messages
- 18
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
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
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>