Solved Using RANK function with more than 1 equal value.

June 20, 2012 at 08:27:16
Specs: Windows XP
I am using the RANK function to rank a list of tenants by rental income on my rent roll and then using Vlookup in a separate table to generate a summary of the top 10 tenants.

The problem is if two tenants have exactly the same rent, my table will only generate the first tenant and none of the others. Does anyone have a good solution to this problem?

Thanks for the help!


See More: Using RANK function with more than 1 equal value.

Report •


#1
June 20, 2012 at 09:15:49
✔ Best Answer
To break the tie, you will need another parameter of some type.

Do you have some type of data that could be used to break the tie?

MIKE

http://www.skeptic.com/


Report •

#2
June 20, 2012 at 09:18:48
Found the solution here for any interested:

http://www.ehow.com/how_5801074_ran...


Report •
Related Solutions


Ask Question